Formatting

G

Guest

I have a phonebook where I want to fill every other line with a gray
background color. Is there any way to do this wheen the report is loaded?
 
F

fredg

I have a phonebook where I want to fill every other line with a gray
background color. Is there any way to do this wheen the report is loaded?
Click to expand...

Make sure the BackStyle of each control is Transparent.

Code the Detail Format event:

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

====
If you wish each page to start with a white row, code the Page Header
Format event:

Me.Detail.BackColor = 12632256 'Reset color to Grey so that the
first detail line will become white

Change the colors as needed.
 

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

detail formatting 1
Report Can Grow not aligned horizontally 2
Column wrap a single field into 2 or more columns per page? 2
print to pdf without prompt or dialog box 2
Alternate background color 2
Access reports and forms have gray background and print as gray 0
email a report with formatting to word for editing 1
How to save a report so it can be emailed? 3

Top