BackColor Field Change in Access Report 1

[EBox]

I have a report which lists a report of the year to date. There is a field entitled [Month] which is in date format mmm/yyyy, and I would like to be able to make a yellow BackColor of a report field named Highlight when the [Month] is the last one in the report (or, 30 days from today).

I'd like to set it up so that whenever I run the report, the most recent completed month has the Highlight box with a yellow BackColor, so that this data gets "highlighted".

Can anyone help with the programming in VB code here?

Thanks,
Eric

 

[nfell]

You need to use the OnFormat of the Detail of the report, and use code similar to this -

If DateAdd("m", 1, Me.b) >= Date Then
Me.b.BackStyle = 1
Me.b.BackColor = 65535
Else
Me.b.BackStyle = 0
End If

Where Me.b is the field on the report that you want to change the colour of. The DateAdd function in this example just adds a month to the date specified (Me.b).

Hope it helps.