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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

removing shaded area 0
access report format 1
Column shading 1
how do you shade alternating lines in a tabular report 11
Word Dashed line formatting 0
Shadebox to grow with memo textbox 2
shading lines of data 9
Alternate Shading 3

Back
Top