Conditional Formating Problem

  • Thread starter Thread starter Anatoly Kurilin
  • Start date Start date
A

Anatoly Kurilin

Hi, what should I put in a condtional text box to make formating work when
the field is equal to NULL?

Thank in advance,
A.Kurilin
 
Well, nothing is "equal to null". But is you want to format a field that is
null in a certain way, just use IsNull.

Set the first dropdown to "Expression Is"

In the second field, enter your expression. Something like:

IsNull([YourFieldName])

Then tell it how you want null values formatted.
 

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 Formating Question 3
DateDiff Conditional Formating 2
Conditional formatting -can I test for emptiness? 5
Conditional Format text Excel 2003 2
Copy condtional formatting in XL2007 for Windows 1
Conditional formatting 8
Conditional Formatting Question 3
Continuous forms 1

Back
Top