Report Lines, Shaded

[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

 

[Marshall Barton]

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.

 

[R. BRADFORD THOMAS]

Thanks Marsh,
I will try this tonight.

Brad

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.