Background colour dependant on a null

[Sgt Bilkp]

Evening again.

Probably a quick one for the folks on here (and yes, have tried a search but getting conflicting and confusing returns?).

In a subform (frmFaults) i need the background colour to show up red, when a text box date field (bound) [Date_returned) contains a null value.

Any takers?

 

[Luddite Lad]

Have you tried conditional formatting of the cell?

 

[Sgt Bilkp]

Have you tried conditional formatting of the cell?

Sorry, i meant to say background colour of the whole sub-form. On balance, i may try just highlighting the cell. May be easier. Cheers

 

[Banana]

Also, you can use Nz() function, which is usually used to return a zero in event of null, but I am sure they provided a mean for you to return a value of your own choosing if it's null.