Add color to a field

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

I need to make the font of one field show in Red if the
value is before 1999, otherwise it needs to be Black. Can
this be done?

Thanks!
Sara
 
Hi Sara

check out conditional formatting (format / conditional formatting) on the
field - get back to us if you get stuck.

Cheers
JulieD
 
I need to make the font of one field show in Red if the
value is before 1999, otherwise it needs to be Black. Can
this be done?

Thanks!
Sara
Click to expand...

Yes it can be done.
If you are using access 2000 or newer you can use the control's
Conditional Formatting property to change font color in both single
and continuous form view.

If you are using Access 97 or older you can, using code, change the
font color, but only in Single Form view.
 
Back
Top