Conditional Formating Problem

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
 
R

Rick B

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