Shading Even Rows on Reports 2

[marc0042]

I was wondering is there a way to shade even rows in Access on a Report.

 

[PaulBricker]

This faq should help.
faq703-2684

Paul

 

[rgbanse]

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Detail.BackColor = vbWhite Then
Detail.BackColor = 13487565
Else: Detail.BackColor = vbWhite
End If
End Sub

RGB

 

[MichaelRed]

as a simpler variation, consider:

MyClr = rgb(64, 64, 64)     '~~ Lt Grey
? MyClr
 4210752 
? vbBlack
 0 
Clr = vbWhite
? Clr
 16777215 
Clr = Clr Xor MyClr
? Clr
 12566463 
Clr =  clr Xor MyClr
? Clr
 16777215

MichaelRed