Access Report formatting by date

[adamdunko]

I want to change the background color of a record in a report if the date field has already passed.. Not sure how to do this. Please help!~

 

[Trendsetter]

you need to enter code in the form behind the report.
I usually use one of the Header On_format section and type something like:

If Me.txtDate > Date() Then
Me.txtDate.Backcolor = 255 ' Red
Else
Me.txtDate.Backcolor = 16777215 ' White
End if

 

[KBCobra]

If this report is more than one page (record) you should create an iif() statement in a field on the page header section that evaluates the date and takes action.

 

[CosmoKramer]

You could also perform the code in the detail section. See this thread: thread703-527296