detail formatting

M

mcnewsxp

how can i change the fill color for the detail line every other line - from
no color to gray?

tia,
mcnewsxp
 
F

fredg

how can i change the fill color for the detail line every other line - from
no color to gray?

tia,
mcnewsxp
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

I screwed up 0
Tracked changes by multiple people modified to one 0
Address Format changed after Migration 0
Printing from Word my Inserted Pictures colors are dull and lack color 0
Need help modifying code 0
Layout Guide color 0
search and replace query for a value in every column 5
Changing row background from external program 0

Top