Condional formatting based on current date

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

Guest

I have a field which I would like to change colour using conditional
formatting when a date has elapsed. So basically I need Access to know
today’s date so that it can apply conditional formatting to this field.

Many thanks Ian
 
if you are using access 2000 or higher, select the controls you want and go
to format->conditional formatting on the menu bar. You can change the
criteria to an expression and use that.
 
If you want to know that the date entered is in the past then in the three
text boxes in the conditional formatting wizard:
1. Field Value Is (default)
2. Is Less Than
3. Date()
 

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

Date and Time 3
Assign today's date to field based on combo box choice 1
Using Dates in Conditional Formatting 9
change cell colour according to date..... 2
date popping up in error 2
Conditional Format 3
conditional format 2
Conditional Formatting - I just don't see what I'm doing wrong. 3

Back
Top