franke Master Poster
Joined: 26 Jun 2004 Posts: 161 Location: Indiana, USA
|
Posted: Fri Dec 28, 2007 1:13 pm Post subject: How to make your report a "greenbar" report |
|
|
Put the following code on the On Format event of the Detail section of your report.
I will create alternating lines or bars of a different color, in this case green for that greenbar look (you could also make it gray for a graybar effect on a black and whit printer).
Code: | Option Compare Database
Dim greenbar As Boolean |
Code: |
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If greenbar Then
Detail.BackColor = 12181965
Else
Detail.BackColor = vbWhite
End If
greenbar = Not (greenbar)
End Sub |
|
|