Resetting the background color

[Roni1]

I would like to reset the background color for a new Group.
I used the "If Remainder(RecordNumber,2)=0 Then Silver Else NoColor", and it works find ... but
If the last detail section of the previous group end with background, the new detail section for the new group will not have any background color.
Every first record for every group should start with the Silver background color.
Any help is appreciated.

 

[Naith]

Create a running total, which resets at the group level, and place it in your detail section.

Refer to the running total formula instead of the RecordNumber reference in your colour formula.

So you should end up with something like:

If Remainder({RunningTotal},2)=0 Then Silver Else NoColor

Naith

 

[Roni1]

Naith,

Why didn't I think of that?
It worked perfectly.
Thank you so much!
Roni