highlighting certain dates in a report.. how?

[benzo1]

Dear Access gurus,

I have a report that displays dates from a control source. I want to highlight dates in two colors, that represents two sets of chronologies.

Red would represent anything past the date at which the report was/is to be generated, amber for any dates that are within 3 months away from the date that the report was generated.

The control source field is called "DecomDate"

How can I go about doing this?

Thanks in advance

 

[jfischer]

You can use the On Format event of the Detail section to set the BackColor property of the control to the desired color based on its date value. For example:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
  If Me!DecomDate < Forms!frmReportPick!ReportDate Then
    Me!DecomDate.BackColor = 255   'Red
  ElseIf Me!DecomDate < (Forms!frmReportPick!ReportDate + 90) Then
    Me!DecomDate.BackColor = 33023 'Amber
  End If
End Sub