I am trying to change the back color of each row on a report depending what row number it is on.
I am trying to use a Rectangle with controls over top of it, the controls have their background style set to transparent.
my Code says.
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Static Counter: Counter = Nz(Counter, 1)
Counter = Counter + 1
If Counter Mod 2 = 0 Then
ColorBox(FormatCount).BackColor = vbWhite
Else
ColorBox(FormatCount).BackColor = 12632256
End If
End Sub
How do I correctly set the backcolor of a rectangle when the report is being formatted? Or should I use a different control for the backcolor?
Thanks for your time