Condional formatting based on current date

N

NoviceIan

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
 
J

Josh Nankivel via AccessMonster.com

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.
 
K

Klatuu

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()
 
Top