Formatting fields

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

I have a question on form with 5 possible selections. I have set each field
to a red background until a selection is made using conditional formatting.
I want to 5 fields to revert to a white background if a selection is made in
any of the five fields. Any suggestions.
 
It sounds as if you need conditional formatting set to something like the
following on all the controls

Expression is: [Field1] is null and [Field2] is null and [Field3] is null and
[Field4] is null and [Field5] is null

Or it could be that you will have to use the IsNull function

Expression is: IsNull(Field1) AND IsNull(Field2) AND IsNull(Field3) AND
IsNull(Field4) AND IsNull(Field5)

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