View Single Post
  #2  
Old May 18th, 2004, 08:15 AM
Marshall Barton
external usenet poster
 
Posts: n/a
Default Greenbar in report

Microsoft News wrote:

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



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
--
Marsh
MVP [MS Access]