Greenbar in report

  • Thread starter Thread starter Microsoft News
  • Start date Start date
M

Microsoft News

Anyone know how to produce alternate grayed lines in a report; what used to
be called greenbar? Makes it easier to find lines.
Thanks in advance,
Bill
 
Microsoft said:
Anyone know how to produce alternate grayed lines in a report; what used to
be called greenbar? Makes it easier to find lines.
Click to expand...


Set all of the controls to have their BackStyle Transparent.
Then add some code to the detail section's Format event
procedure

If Me.Section(0).BackColor = vbWhite
Me.Section(0).BackColor = RGB(220,220,220)
Else
Me.Section(0).BackColor = vbWhite
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shading in Reports 2
How do I green band in a Form 3
Alternate shading of rows on a form 2
Cell Format - Greenbar Fill Pattern 4
named range in conditional formatting 3
coding greenbar 10
Highlight rows if duplicates are found 3
how do you shade alternating lines in a tabular report 11

Back
Top