changing forecolor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mccoy - 16 Mar 2007 05:05 GMT

i have a continous form and i put the ff. code on "on current" event

If Me.combo1.Value = "CASH" Then
Me.textbox1.ForeColor = vbRed
Me.textbox2.ForeColor = vbRed
ElseIf Me.combo1.Value = "CHECK" Then
Me.textbox1.ForeColor = vbBlue
Me.textbox2.ForeColor = vbBlue

the problem is if the first record is set to "CASH" all the said textbox is
color in red
even the second record although it is set to "CHECK". is there a right way
to do this

Reply to this Message

Allen Browne - 16 Mar 2007 05:47 GMT

Assuming Access 2000 or later, use Conditional Formatting.

It's on the Format menu, in form design view.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>i have a continous form and i put the ff. code on "on current" event
>
[quoted text clipped - 10 lines]
> even the second record although it is set to "CHECK". is there a right way
> to do this

Reply to this Message