Alternating Shading on Report Lines

[R. BRADFORD THOMAS]

Good Evening,
I use Windows 2000 and access 2000.

A few weeks ago Marsh help me with alternate shading on report lines in the
detail section of a report.

I now need to have alternate shading on report lines in the first Group
Level section of my report. I have no detail lines. (At least they are not
visible on the report)

For a Detail Section the coding that works is as follows:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Section(0).BackColor <> vbWhite Then
Me.Section(0).BackColor = vbWhite
Else
Me.Section(0).BackColor = RGB(224, 224, 224) ' Lt. Gray
End If

End Sub

I tried changing Section (0) to another number; however, this doesn't work.

Any suggestions will be helpful.

Thanks
Brad

 

[Roger Carlson]

On my website (see sig below) is a small sample database called
"Greenbar.mdb" which illustrates how to alternate colors in both Details and
GroupHeaders.