Shading alternate lines

  • Thread starter Thread starter Cathy C
  • Start date Start date
C

Cathy C

Is it possible to shade every other row on a columnar Access report and if
so, how?

Thanks,
Cathy
 
You can set the On Format code to something like:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim lngLightGreen As Long
lngLightGreen = 13434828
If Me.Detail.BackColor = vbWhite Then
Me.Detail.BackColor = lngLightGreen
Else
Me.Detail.BackColor = vbWhite
End If
End Sub
 
Cool! Thanks much.

Duane Hookom said:
You can set the On Format code to something like:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim lngLightGreen As Long
lngLightGreen = 13434828
If Me.Detail.BackColor = vbWhite Then
Me.Detail.BackColor = lngLightGreen
Else
Me.Detail.BackColor = vbWhite
End If
End Sub
Click to expand...
 
Back
Top