>>Ok, got it to work using:
>>
>>
>> .grdAppointmenttypeset.Column10.DynamicBackColor = "IIF( .T., RGB(" + m.BackColors + "), 0)"
>>
>>
>
>You don't need RGB there. What you needed was evaluating the m.BackColors variable at the time you set the property.
>
>
>>Which is good, but no matter what I set the Sparse property to on Column10, it changes the BackColor for all rows.
>>
>
>That's because the condition in the IIF() is .T. You need to substitute the actual condition you want that determines whether to color this item.
>
>Tamar
I'm not sure about all that but I know that this works:
"IIF( .T., RGB(b_red,b_green,b_blue), 0)"
Where the colors are RGB numeric values in the fields of the grid alias.