changing backcolor based on value

D

David Turner

I need to be able to change the backcolor of textboxes based on their value
(i.e. 1= Red, 2 = Green) etc. I know this can be done with Conditional
Formatting in later versions of Access, but I have Access 97.

Can anyone assist

Dave T
 
J

Jeff Boyce

David

It sounds like you'll need to write a small procedure that checks what was
input into the control and modifies the backcolor.

Take a look at Access HELP on the AfterUpdate event, on BackColor, and on
the Case statement.

Good luck

Jeff Boyce
<Access MVP>
 
Top