Color a Form

[Grandchester]

I need a specific field to have the BackColor changed depending on the value that that field has. Example:

If txtbox1 = 3
Then txtbox1.Backcolor = Red

If txtbox1 = 2
Then txtbox1.Backcolor = Yellow

Thanks!!

 

[RichB]

If you are using Access 2000 it is simple. Just click the field you want to change (in Design View) then click Format and then go to Conditional Formating.

If you are using something older than 2000 I can't help, Sorry. You could search this forum for your answer. I know it is here I have seen it.