highlighting text box if...

[spcscooter via AccessMonster.com]

Is there a way to highlight a text box in a form if say, an expiration date
is past due? If so, how?

Thanks for the help,

Scot

 

[spcscooter via AccessMonster.com]

Never mind... I have tunnel vision right now. I figured it out.

Thanks

 

[Rick Brandt]

Is there a way to highlight a text box in a form if say, an
expiration date is past due? If so, how?

Thanks for the help,

Scot

In the Current event of the form have code that tests the expiration date and if
its past due (do something). You can change the background color, the font,
make the text bold, etc..

 

[Minton M]

Is there a way to highlight a text box in a form if say, an expiration date
is past due? If so, how?

Thanks for the help,

Scot

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200712/1

Or, if you're on a later version of Access (2003+?), conditional
formatting can be used.