Highlight field if empty

[nigel brown]

Hi

On my report, I would like to highlight any fields (Text Boxes) that are empty.

I suppose it is a kind of condition formatting like in Excel, maybe not!



Please help

Nigel
VBA Virgin

 

[Galaxiom]

Access has conditional formatting. You can change the BackColor with it.

 

[nigel brown]

Access has conditional formatting. You can change the BackColor with it.

Ok, I will check it out and see if I can find out how to do it.

Kindest Regards

Nigel
or

 

[Galaxiom]

In A2007, right click on the control.