ATXTHA
asked on
column colors in access 2010 report
I need to alternate the back color of the columns in my access report. 4 columns - every other column is "some color". I know you can do that for rows, but I can't find anything about doing it for columns. Is that possible?
If your column fields don't fill up the detail section (height-wise), you can add a colored box behind alternate columns. Just make the height of the box the same as the detail height and set the backcolor property of each box.
ASKER
What I forgot to mention is the columns I'm talking about come from page layout and not from having 4 text boxes in my detail.
What do you mean by "page layout"?
I don't believe you could do that using the column layout. A way you could do this though is to create a subreport and add a subreport control into your report multiple times (each with a different Master/Child link). You could then add code in your OnFormat event to change the backcolor of alternate subreports.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So for the first 4, you'd just have a transparent backcolor, then for the next 4 you'd set the backcolor, and so on.
Unless I'm missing something ...