Alternate line colors in a report

[jacob]

How do I make my report have alternating line colors? Any ideas?

 

[Roger Carlson]

On my website (see sig below) is a small sample database called
"Greenbar.mdb", which illustrates how to do this.

 

[Cheryl Fischer]

Below is a link to a solution provided back in July by MVP John Spencer:

http://tinyurl.com/2q5am


hth,

 

[jacob]

Thank you Roger, that is just what I was looking for.

 

[fredg]

How do I make my report have alternating line colors? Any ideas?

Make sure the BackStyle of each control is Transparent.

Code the Detail Format event:

If Me.Section(0).BackColor = vbWhite Then
Me.Section(0).BackColor = 12632256 ' gray
Else
Me.Section(0).BackColor = vbWhite
End If

====
If you wish each page to start with a white row, code the Page Header
Format event:

Me.Detail.BackColor = 12632256 'Reset color to Grey so that the
first detail line will become white

Change the colors as needed.

 

[Guest]

Roger
Fantastic code. Very simple and easy to follow - I actually understood it. Thank you for providing the sample
Dere

----- Roger Carlson wrote: ----

On my website (see sig below) is a small sample database calle
"Greenbar.mdb", which illustrates how to do this