Formatting a report

[accessuser1308]

Is there a way to format a report such that every other record displayed is
highlighted? For example record 1 would be 'normal' while record 2 would be
highlighted, say yellow, all the way across the report...and so on. Is this
possible in access?

Thank you

 

[Jackie L]

On the On Print Event of the Detail section of your report, add the following:


If Me.Section(0).BackColor = 16777215 Then
Me.Section(0).BackColor = 8454143
Else
Me.Section(0).BackColor = 16777215
End If


Hope this helps,
Jackie