Becky Edwards
asked on
Alternate Row Colors in Group Header
I know there is a way to insert a colored text box and format the text box to alternate from grey to white, to grey to white, etc. I just don't know what to put in the formula box under FILL to make it do that.
Can someone help?
I think it is something like
If {ado.x} <> {ado.y} Then
Formula = crSilver'True
Else
Formula = crWhite 'False
End if
but I do not know what ado.x or ado.y is.
or should be.
Can someone help?
I think it is something like
If {ado.x} <> {ado.y} Then
Formula = crSilver'True
Else
Formula = crWhite 'False
End if
but I do not know what ado.x or ado.y is.
or should be.
ASKER
I moved a whole bunch of stuff into the group header, so I want every other line in the group header to be gray, instead of white. There is no detail line showing, just the group header.
ASKER
Here is a sample of the report.
ExpExchSample.rpt
ExpExchSample.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked perfect! Thanks!!!!!@
The group header only has 1 record
mlmcc