changing background color in a field based on a null value

[Guest]

I would like to run a report using an existing query that lists null values.
If the value is null such as "vision date", I would like to have that null
value field a different color. Now, I am running a report that will show
blank field if the "vision date" is null, I then highlight that field with a
highlighter. I'm sure there is an easier way. Any suggestions would help.

Thanks,
Lee

 

[fredg]

I would like to run a report using an existing query that lists null values.
If the value is null such as "vision date", I would like to have that null
value field a different color. Now, I am running a report that will show
blank field if the "vision date" is null, I then highlight that field with a
highlighter. I'm sure there is an easier way. Any suggestions would help.

Thanks,
Lee

If you are using Access 2000 or newer:

Right-click (in Design View) on the VisionDate control.
Select Conditional formatting
Set the Condition1 drop-down box to
Expression Is
In the next box write:
[VisionField] Is Null

Select the color you want.
Click OK to save the changes.