Formatting fields

[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.

 

[Arvin Meyer [MVP]]

Maybe this will help:

http://support.microsoft.com/kb/304104

 

[John Spencer]

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