Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top