Attach the following code to the report detail section’s OnFormat event:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If ((Me![RecordCounter] - 1) Mod 2 = 0) Then
Me.Detail.BackColor = 12632256
Else: Me.Detail.BackColor = 16777215
End If
End Sub
Of course you can choose whatever colors you want.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.