Is it possible to design a report that alternates the colour in the
detail record?

Yes. See the following KB article:

How to shade every other detail line on a report
http://support.microsoft.com/?id=288154

This article uses white and yellow, but you are free to pick from a long
list of colors.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________


"kdaniel7979" wrote:

> Is it possible to design a report that alternates the colour in the
> detail record?
>
>

On 1 Mar 2006 22:46:50 -0800, kdaniel7979 wrote:

> Is it possible to design a report that alternates the colour in the
> detail record?

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Nice and clean solution.

Thx