MS Access Reports GreenBar or Muliptile color lines
Posted on 2007-08-02
IN my report, I hide the details, but summarized the group results. I'm trying to create a greenbar affect where each other line has a different color. I found this code and tried it, it's not working correctly.
Private Sub GroupFooter1_Print(Cancel As Integer, PrintCount As Integer)
Dim intCounter As Integer
intCounter = intCounter + 1
If intCounter Mod 2 = 0 Then
Me.Section(0).BackColor = "16777215"
Me.Section(0).BackColor = "8454143"