Conditional Formatting - Access 2000

  • Thread starter Thread starter sheldon
  • Start date Start date
S

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


.
Click to expand...
 
Back
Top