IsNull in Conditional Formating

J

Jonathan Smith

I am using Access 2002, with an Access 2000 File Format.

I have a Report that contains approximately 15 Fields in the Detail
Section.

I would like to be able to "HIGHLIGHT" on the Form those fields within the
Detail Section that are BLANK, or contain no value ... these would be text
fields.

Any ideas?
 
A

Allen Browne

With the report open in design view:

1. Select the first field to be highlighted.

2. Choose Conditional Formatting from the Format menu.

3. Set Condition 1 to:
Expression Is [Field1] Is Null
and click the highlight color in the Bucket icon.

4. Repeat for the other fields.

Note: Replace "Field1" with the name of your field.
 
Top