Formatting a report

  • Thread starter Thread starter accessuser1308
  • Start date Start date
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
 
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
 
Back
Top