Conditional Formatting/Date

[lbjcaj]

i Have an access 2007.
the name of my field is scheduledate. so when todays date is reached i would
like it to change backround colors on my field, in a report. Thanks Lonnie

 

[kagard]

Hi Lonnie:

1. Open the report in design view.
2. Select the text box that displays the scheduledate field.
3. Choose on the Design tab of the Ribbon, click the Conditional
button in the Font group.
4. Set Condition 1 to
Field Value is
greater than or equal to
Date()
5. Click OK

Keith

 

[lbjcaj]

Hi Lonnie:

1. Open the report in design view.
2. Select the text box that displays the scheduledate field.
3. Choose on the Design tab of the Ribbon, click the Conditional
button in the Font group.
4. Set Condition 1 to
Field Value is
greater than or equal to
Date()
5. Click OK

Keith



That Works in form, but not in a report.

 

[lbjcaj]

It will show my color change when i click on date. can i get it to show always