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

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com

 

[spcscooter via AccessMonster.com]

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

Thanks

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

Message posted via AccessMonster.com

 

[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

Message posted via AccessMonster.comhttp://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.