Alternate dark and bright backgrounds on report

[Jonathan Blitz]

Is there any way I can alternate between grey and white backgrounds for the
lines of a report.
I want 1 line with white background and one with light grey and so on. These
makes the report far easier to read.

How do I do this?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Felix Fleitas]

-----Original Message-----
Is there any way I can alternate between grey and white backgrounds for the
lines of a report.
I want 1 line with white background and one with light grey and so on. These
makes the report far easier to read.

How do I do this?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."


.
Go to Microsoft's knowledge base and pull out this

Article # Q210392 Titled: How to shade every other detail
line on reports.

Hope this helps.
Felix Fleitas
Miami, FL

 

[Rick Brandt]

Is there any way I can alternate between grey and white backgrounds for the
lines of a report.
I want 1 line with white background and one with light grey and so on. These
makes the report far easier to read.

How do I do this?

If it is the Detail section (Section(0)), then in the OnFormat event of
that section use code similar to...


If Me.Section(0).BackColor = 16777215 Then 'white
Me.Section(0).BackColor = 12632256 'gray
Else
Me.Section(0).BackColor = 16777215 'white
End If

 

[Jonathan Blitz]

Many thanks. It worked perfectly.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."