Greenbar in report

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