conditional formatting

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hello:

I want to make the field "a" turn blue when field "b" is
0. I know that I have to use an expression (instead of
Click to expand...
the field between...) but I can't figure out the exact
language to use.
Please help.

Thanks,

Gary
 
What version of Access?
In Access 2000 and later, you can code the A control's
Conditional Formatting property.

Set the Condition 1 drop down to:
Expression Is
Enter
> 0
in the text box alongside the drop down.
Select the color wanted.
 
Back
Top