Group Footer to alternate color

[lanm]

I'm trying to get every other group footer to be a different color, and can't seem to get the distinctcount() function to work. I also tried the count() function, but that's always giving me 1.

Any suggestions are welcome!

Thanks!

 

[lanm]

I have a counter for the grouping, and the expression is:
=rownumber(Nothing)

This works, and it's in a textbox name textbox31.

I'm trying to get the value of the textbox for the background color expression, but can't seem to do it with: textbox31.value

 

[lanm]

Got it by simply adding this to the group footer background color property:

= iif (rownumber(Nothing) mod 2, "White", "Gainsboro")