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))"