Formatting a report

A

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
 
J

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
 
Top