Dan

Thanks for your reply. This should sort it out

Regards,

Gerard


>Gerard,
>
>>I am trying to set dynamic background color of Grid Rows:
>>For each loColumn in This.Columns
>> With m.loColumn
>> .DynamicBackColor = "Iif(Mem.Mem_Status='SUP',RGB(255,0,0),;
>> IIf(Recno() <> This.inCurrentRecNo,RGB(255,255,255),RGB(0,255,0))"
>> EndWith
>>EndFor
>
>Since, the IIF statement is a text string not an expression you need a close quote before the at the end of the line.
>
>As in:
>
>

>
>   .DynamicBackColor = "Iif(Mem.Mem_Status='SUP',RGB(255,0,0),"+;
>      "IIf(Recno()  This.inCurrentRecNo,RGB(255,255,255),RGB(0,255,0))"