Condional formatting based on current date

[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

 

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

 

[Guest]

What would the expression be?

 

[Guest]

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