IsNull in Conditional Formating

  • Thread starter Thread starter Jonathan Smith
  • Start date Start date
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?
 
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.
 
Back
Top