Conditional formatting for a differnet field

[Amer]

Hi

In Access 2007, I want a field to change its formatting automatically based
on the value of a different field on the same form.

For example: a field named "Employee's Name" should become red when the
field "Status" equals 'Terminated'.

Thanks a lot.

 

[John Spencer]

Use the Expression Is option of conditional formatting

Choose "Expression Is" from the combo-box and then enter
[Status] = "Terminated"

This assumes that the field Status is available in the form's record source
and stores a text value "Terminated".

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County