conditional formatting on Null field

  • Thread starter Thread starter Terrell Miller
  • Start date Start date
T

Terrell Miller

probably a real easy question:

how do you specify a Null criteria in conditional
formatting?

IOW, I want the control to turn red or whatever if there
is nothing in the underlying field. Tried using "", Null,
and less than "a", nothing works.

Thx,

Terrell
 
From the first combo box, select "Expression is". Then, in the TextBox,
enter:

IsNull([MyField])
 
Back
Top