Alternating Report background? (AXP 10.2627.2625)

Topic

New Reply

How do I print a report such that every EVEN line has a light gray background. The idea is to allow easy reading across a landscape format page. It seems that I will have to code the writing of each line myself (?) but i would of course prefer that Access do the work right out of the box.

In the above, “even” could be variable, so that a report could be printed with every other pair, or every tuple, of lines grayed.

At the moment, I’m only looking at gray, not color. I’ve also thought of using precolored paper.

Reply | Quote

Replies

I don’t know if AXP have this build in but you could use this in the On Format of the Detail Section:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   Const vbLightGrey = 12632256
   If Me.CurrentRecord Mod 2 = 0 Then
      Me.Section(acDetail).BackColor = vbLightGrey
   Else
      Me.Section(acDetail).BackColor = vbWhite
   End If
End Sub

Reply | Quote

Egg ZACKLY what i wanted!

Thanks Francois

Reply | Quote

What I have found is that the Light grey is in fact too dark on the report, I have used vbYellow instead of Light Grey for a much lighter grey effect.
HTH
Pat

Reply | Quote