Shade Alternate Rows (in Report that uses Crosstab Query

[papic1972]

Hi All,

Is it possible to shade alternate rows in a report that uses a CrossTab query as its record source.

I have tried:

'Michael Red. 2/13/2002. To 'Toggle the backolor, which
'Provides alternate line shading
Const XorToggle = 4144959

Me.Detail.BackColor = Me.Detail.BackColor Xor XorToggle

but each line is white. Can anyone offer any help?
Thanks in advance.

 

[dhookom]

Where did you place the code?
I generally use code like:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    If Me.Section(0).BackColor = vbWhite Then
        Me.Section(0).BackColor = 12632256
     Else
        Me.Section(0).BackColor = vbWhite
    End If
End Sub

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]