>Hi All
>
>I have a grid which I want to set the forecolor based on a value, the code is like this:
>
>oGrd.SetAll("dynamicbackcolor", "", "Column")
>oGrd.SetAll("dynamicforecolor", "", "Column")
>
>oGrd.SetAll("dynamicforecolor", ;
> "IIF(Credit > 0,RGB(0,121,0), RGB(198,0,0))", "Column")
>
>The above works fine, but I want to change the color of column 6 according to the balance value, so i tried:
>
>oGrd.Columns[6].SetAll("dynamicforecolor", ;
> "IIF(balance > 0,RGB(0,0,255), RGB(0,0,0))", "Column")
>
>also tried
>oGrd.Column6.DynamicforeColor = IIF(balance > 0,"RGB(0,0,255)", "RGB(0,0,0)")
>and again no luck.
>
>Any help is much appreciated.
>
>Thanks
oGrd.Columns[6].Dynamicforecolor = "IIF(myAlias.balance > 0,RGB(0,0,255), RGB(0,0,0))"
PS: Include alias as in sample.
Cetin