Conditional formatting 2007

[Egg 'n' Bacon]

I'm looking for the correct syntax to colour a field (on a form) based on another field being blank or null, and failing

Any ideas would be very much appreciated.

TIA

[HansV]

Select "Expression Is" from the first dropdown in Condition 1.
Enter an expression like this:

[OtherField] Is Null

where OtherField is the name of the field that should be blank.
Apply the formatting that you want, then click OK.

[Egg 'n' Bacon]

Cheers Hans