Turn Date Red after expire

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

dragonlight

Thread Starter
Joined
May 30, 2002
Messages
347
I am looking for some information or a code that will turn the expiration date bold red or just red, when it's past the current date, otherwise just have the date color green or black. I am using Access 2003.

Thanks.
 
Joined
Jul 1, 2005
Messages
8,546
I have Access 2K, tho' I don't really use it.

I read that for a textbox on a form linked to a date field in a table, you can (with the box selected in Form Design mode), select "Conditional Formatting" from the "Format" menu ... and then define Field Value Is -- less than -- Date(). Looks you can set three conditions, so that should do if you just need the two.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top