Validation on a form (1 Viewer)

[rayn]

Hi

I would like to apply a conditional formatting type of thing like in excel. i am not sure if this is possible in access.

OK

My question is this.
i have a cell in my field in my subform in which i enter if an invoice has been paid or not. if the invoice has been paid i usually entere the date it was paid at. now if it hasn't been paid i just put NOT PAID. i would like access to highlight the cell in which i enter NOT PAID in red and when i enter a date the formatting goes away. (or something to distinguish that it hasn't been paid) is this possible?????

Thank you very much

Regards
Rayn

 

[pbaldy]

If you're using Access 2000 or later, Format/Conditional Formatting will do what you're asking.

 

[Rich]

Add an unbound text box, set the control source to =Iif (IsDate([YourField]),"Paid","NotPaid")