Shading alternate lines

C

Cathy C

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

Thanks,
Cathy
 
D

Duane Hookom

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
 
C

Cathy C

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
 

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
how do you shade alternating lines in a tabular report 11
Column shading 1
Word Dashed line formatting 0
Alternate Shading 3
shading lines of data 9
alternate line shading 1

Top