Alternate dark and bright backgrounds on report

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

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."
 
-----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
Click to expand...
Article # Q210392 Titled: How to shade every other detail
line on reports.

Hope this helps.
Felix Fleitas
Miami, FL
 
Jonathan Blitz said:
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?
Click to expand...

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
 
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."
 
Back
Top