Conditional Formatting - Access 2000

[sheldon]

Hi,

I am using conditional formatting for a field. I want the
field background to be red if the field is blank. How do
I set the conditions?

Thanks.

Sheldon...

 

[tina]

if you're using the Format, Conditional Formating menu
option, try the following:

instead of using Field Value Is, change the selection to
Expression Is. Then, using the correct fieldname, write in
the expression Fieldname Is Null, and set the background
color to red.

hth

 

[Sheldon]

Thanks!

-----Original Message-----
if you're using the Format, Conditional Formating menu
option, try the following:

instead of using Field Value Is, change the selection to
Expression Is. Then, using the correct fieldname, write in
the expression Fieldname Is Null, and set the background
color to red.

hth


.