Alternate Line Color

[Joseph]

I have to use Office2k and Office07 at my work. I like to added feature of
the alternate line color in office07. But it does not work in O2k. So I
added a counter and some code under the detail format event:

select case me.counter mod 2
case 0
detail.backcolor = rgb(223,223,223)
case else
detail.backcolor = rgb(255,255,255)
end select

It works fine, except that it only colors about 1.5 inches on the left and 1
inch on the right. Everything in the middle is uncolored. I have several
reports that are like this. I keep the databases in O2k format, but often
decompile, resave in Office07, and recompile, alter the databases then do it
all over for O2k. Any clues to why this is doing this?

 

[John Spencer]

Are your controls in the detail section transparent? If not they could be
blocking the background color of the section.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Joseph]

I have already checked that and no the boxes are transparent. Well, let me
rephrase that. There is one box that is not transparent due to that I have it
changing colors per the month, but the other 14 columns are transparent.

 

[John Spencer]

Well I am stumped. I can't see any reason that is would not work.

Anyone else have any ideas?

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Duane Hookom]

I would do some troubleshooting by changing all the background colors of the
controls to different values. Then print/preview the report to see if it
helps identify the issue.