changing backcolor based on value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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>
 
Back
Top