How do I get a date on a form to show in red only if it is past?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a form that will display a date in RED if it is older
than today's date (in other words EXPIRED) but display in black if not.
Anybody know how to do this?
 
Have a look at Conditional Formatting on the Format menu.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format of a control 2
Excel High lightng dates in future, today and past 1
Change color on date field in form for re-certification 1
Excel Colour code dates 1
How to change text color based on date value? 2
Conditional formating of dates in a form 1
Arithmatic on Dates 2
Excel Formatting with dates 3

Back
Top