"Bob Morvay" <r@r.com> wrote in message
news:%23TonMnWXFHA.3760@TK2MSFTNGP15.phx.gbl...
>I am trying to set an alternate shading style for each set of grouped
>detail rows that I have. I can easily set each row to an alternating shade
>by creating an expression on the Background color. What I really need is
>to shade a grouping of rows in alternate style. I tried to create a custom
>shared function that the Background expression could use but it only shades
>the first cell of the row because each textbox calls this function. Any
>insight???
>
> Here is the little defunct function that I created...
>
> Shared m_stunum as string = ""
>
> Shared Function getShadeColor(ByVal p_stunum As String) As String
> If m_stunum <> p_stunum Then
> m_stunum = p_stunum
> Return "YellowGreen"
> Else
> Return "White"
> End If
> End Function
>
> and at the row I set the background expression to: =Code.getShadeColor(
> Fields!stunum.Value)
>
> This did not work...
>
> Thanks in advance.
>