Greenbar in report

M

Microsoft News

Anyone know how to produce alternate grayed lines in a report; what used to
be called greenbar? Makes it easier to find lines.
Thanks in advance,
Bill
 
M

Marshall Barton

Microsoft said:
Anyone know how to produce alternate grayed lines in a report; what used to
be called greenbar? Makes it easier to find lines.
Click to expand...


Set all of the controls to have their BackStyle Transparent.
Then add some code to the detail section's Format event
procedure

If Me.Section(0).BackColor = vbWhite
Me.Section(0).BackColor = RGB(220,220,220)
Else
Me.Section(0).BackColor = vbWhite
End If
 
Top