auto formatting report

  • Thread starter Thread starter _Bigred
  • Start date Start date
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
 
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.
 
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.
 
Back
Top