Alternate colors in report

L

Ladi

Hi everybody,

Is there any chance to alternate colors in report with tabular data?

Ladi
 
R

Rick B

What do you mean? What are you specifically trying to accomplish?

What determines which data is colored which color?

What do you mean by tabular data?
 
F

fredg

Hi everybody,

Is there any chance to alternate colors in report with tabular data?

Ladi
Click to expand...

Do you mean alternate detail row colors?

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