changing forecolor

G

Guest

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
 
A

Allen Browne

Assuming Access 2000 or later, use Conditional Formatting.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF THEN..Loop..what is best for this.? 15
Flashing Labels 6
Change Properties of Control 8
Option Groups Is the value in the button or the grouping structure 2
Toggle Button Text Color 1
On Current update issue 1
Changing fore and back colour of a combo box 3
How to let certain TxtBoxes blink & change fore color? 2

Top