>>>>>>>I had an IIF statement in the dynamicBackcolor property of a grid that wasn't working correctly. So I started to try and figure out what was wrong and then realized I can't get the DynamicBackColor to work at all for me. I must be doing something wrong...I have ="rgb(255,0,0)". I've tried it with and without the quotes.
>>>>>>
>>>>>>DynamicBackColor usually includes IIF function, e.g.:
>>>>>>**** Grid.Init event
>>>>>>cLine1="IIF(recno="+this.tag+",16711680,8421376)"
>>>>>>this.SetAll("DynamicBackColor",cLine1,"Column")
>>>>>
>>>>>Hi Edward,
>>>>>
>>>>>I put the following line in the grid's init event:
>>>>>
>>>>>cLine1="IIF(schedule.sch_absent = .t., rgb(255,0,0), rgb(0,255,0))"
>>>>>this.SetAll("DynamicBackColor",cLine1,"Column4")
>>>>>
>>>>>But the column's BackColor is still white do you see anything else that I am doing wrong?
>>>>>
>>>>>Paul
>>>>
>>>>For column4 only use:
>>>>This.Column4.Dynamicbackcolor="IIF(schedule.sch_absent=.t.,255,65280)"
>>>
>>>I did exactly that...still doesn't work.
>>>This blows my mind.
>>>
>>>Any other ideas?
>>
>>It should work. The last thing to check is to make sure that you don't have spaces in "IIF....", i.e issue also
>>This.Column4.Dynamicbackcolor=alltrim(This.Column4.Dynamicbackcolor)
>
>This didn't work either...it seems to me that something is keeping the DynamicBackColor from ever being evaluated.
Sorry, I don't see how to help here. You probably could make some quick tests with Dynamic properties to get familiar with them...
Edward Pikman
Independent Consultant