highlighting text box if...

  • Follow


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
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200712/1

0
Reply spcscooter 12/27/2007 10:21:26 PM

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

Thanks

spcscooter wrote:
>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
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200712/1

0
Reply spcscooter 12/27/2007 10:26:07 PM


spcscooter via AccessMonster.com wrote:
> 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..

-- 
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com 


0
Reply Rick 12/27/2007 10:31:18 PM

On Dec 27, 2:21 pm, "spcscooter via AccessMonster.com" <u30679@uwe>
wrote:
> 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.
0
Reply Minton 12/27/2007 10:39:45 PM

3 Replies
276 Views

(page loaded in 0.203 seconds)

Similiar Articles:
















7/23/2012 8:48:13 AM


Reply: