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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format doesn't? 1
how to apply conditional formatting of one field to whole record 2
How do I "tie" fields together. 1
Conditional formating in a footer of a form 2
Conditional Date Formatting 2
Conditional Formating not working... 2
Conditional Formatting on form fields 2
Changing Form background color conditional format 3

Back
Top