Formatting reports - shade alternate lines (1 Viewer)

B

billburton57

Guest

• Jan 13, 2003

• #1

I'm trying to figure out how to shade alternate detail lines in a report. Any ideas?

 

Autoeng

Why me?

Local time

Yesterday, 19:20

Joined

Aug 13, 2002

Messages

1,302

• Jan 13, 2003

• #2

See www.rogersaccesslibrary.com in the sample library for greenbar.

Autoeng

 

Fornatian

Dim Person

Local time

Today, 00:20

Joined

Sep 1, 2000

Messages

1,396

• Jan 13, 2003

• #3

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Const Grey = 16777215
Const White = 12632256
Me.Detail.BackColor = IIf(Me.Detail.BackColor = White, Grey, White)
End Sub