Alternate row color for Group

[Rhubie]

I am kind of new to access reports - I have created several with alternating row colors with no problem
Now I have added a group to the report detail - I am trying to have the same type of alternating row colors with in the group - I can not get this to work

I would also like to break after each code category also. See example below - I hope that it makes sense

Category - 06
06-C0071 Alternate Row Color
06-C0072 Background Color
Background Color
06-D0122 Alternate Row Color
Background Color

[rpeare]

http://www.datapigtechnologies.com/f...minreport.html

Just do your running sum in the example OVER GROUP not OVER ALL

[Rhubie]

I am working with the example - not working correctly and I see the numbers for the linenumber
If I say over group - it colors everything

[Rhubie]

i did get the colored lines to show if I use the Over All - but still have problem with the line number showing

[rpeare]

a couple of things
set the BACK STYLE of your data fields to TRANSPARENT
make your LINENUMBER field a separate field and set the VISIBLE property to FALSE
Then do the conditional formatting on a different text box

[Rhubie]

I did change all of the data fields to Transparent - I did get the row colors - but when I change the visible to False and the conditional formating on another text box (I did not have a text box in the detail section - so I added it to the category text box) I only got the colored row on the category text box.

[rpeare]

I don't think you're following

have a text box with =1 as the control source, set the RUNNING SUM field to OVER ALL, set the visible property of this field to FALSE

Don't do any conditional formatting in that field

Create a second text box with nothing as the control source, set the condtional formatting of that field to ([LineNumber] mod 2) and set the appropriate background color, set the visible property of this box to TRUE

[Rhubie]

Got it - thank you