Add color to a field

[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

 

[JulieD]

Hi Sara

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

Cheers
JulieD

 

[fredg]

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

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.