Formatting

T

twen

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

Changing row background from external program 0
How to automate update on weekly reports spreadsheet 0
Dealing with a Pivot Table (when I don't want to) 0
Shading inside a heading 11
Solved Disk Full error message when exporting PDF 0
Space at end of multi page list to accommodate new entries 1
Address Format changed after Migration 0
Table of content - format does not get saved 2

Top