Alternate line color on report output

  • Thread starter Thread starter LisaB
  • Start date Start date
L

LisaB

Does anyone know how to get the detail section of a report to print in
alternate line colors?


Doug Smith
2121

Emmanuel Lewis
2541

Eric Flowers
2145

Erika Smith
2374

Erika Thomas
2377
 
Hi Lisa

Use your report's Detail_Format event procedure to toggle the section's
BackColor:

Const LightCyan = &HFFFFC0 'RGB(192, 255, 255)
With Me.Detail
If .BackColor = vbWhite Then
.BackColor = LightCyan
Else
.BackColor = vbWhite
End If
End With
 
Back
Top