conditional formatting on Null field

[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

 

[Cheryl Fischer]

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

IsNull([MyField])

 

[Terrell Miller]

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

IsNull([MyField])

bingo!

thanks, Cheryl.

TM