J
jacob
How do I make my report have alternating line colors? Any ideas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Carlson
On my website (see sig below) is a small sample database called
"Greenbar.mdb", which illustrates how to do this.
"Greenbar.mdb", which illustrates how to do this.
C
Cheryl Fischer
Below is a link to a solution provided back in July by MVP John Spencer:
http://tinyurl.com/2q5am
hth,
http://tinyurl.com/2q5am
hth,
J
jacob
Thank you Roger, that is just what I was looking for.
F
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.
G
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
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