Report Lines, Shaded

  • Thread starter Thread starter R. BRADFORD THOMAS
  • Start date Start date
R

R. BRADFORD THOMAS

Good Morning,
I am using Windows 2000 and Access 2000.

I want to have alternate lines of my report shaded.

How do I accomplish this??

Brad
 
R. BRADFORD THOMAS said:
I am using Windows 2000 and Access 2000.

I want to have alternate lines of my report shaded.


Add code to the detail section's Format event procedure:

If Me.Section(0).BackColor <> vbWhite Then
Me.Section(0).BackColor = vbWhite
Else
Me.Section(0).BackColor = RGB(224,224,224) ' Lt. Gray
End If

Make sure that all the controls in the detail section have
their BackStyle property set to Transparent.
 
Thanks Marsh,
I will try this tonight.

Brad

Marshall Barton said:
Add code to the detail section's Format event procedure:

If Me.Section(0).BackColor <> vbWhite Then
Me.Section(0).BackColor = vbWhite
Else
Me.Section(0).BackColor = RGB(224,224,224) ' Lt. Gray
End If

Make sure that all the controls in the detail section have
their BackStyle property set to Transparent.
 
Back
Top