auto formatting report

B

_Bigred

(Office XP - Access)

How do I autoformat a report so that every other row is grey (or color of
choosing)?

I used to have this from a previous post, but somehow lost it.

I.E Row 1 white
Row 2 grey
Row 3 white
Row 4 grey
and so on.

TIA,
_Bigred
 
R

Rick B

Do a search and find this in previous posts. This is a pretty common
question. Some good keywords that will help you find previous posts include
"stripe" "greenbar" "alternate shading" etc.
 
J

John Spencer

FROM an earlier post

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 = 16777215 'Reset color

Change the colors as needed.
 
Top