>>>I have having trouble with the use of that code I am using
>>>
>>>
>>>thisform.Grid1.SetAll("DynamicBackColor",IIF(thisform.grid1.ctime.combo1.value="0800", RGB(255,255,255), RGB(0,255,0)), "Column")
>>>
>>>I get the error "data type is invalid for this property".
>>
>>Hi Evan,
>>
>>Sorry it took a while to respond. The info I gave you was directly out of VFP's help. I tried what you are doing and got the same error. I am not 100% sure what the problem is but I'm almost positive it's the IIF. Try going to the DynamicBackColor of one of your grid columns and go into the formula builder (...). Play around with your syntax from above until it tells you it's valid and then try the revised syntax in the SetAll statement.
>
>The problem was that IIF... part should be in quotes.
Thanks Ed. How much of the IIF should be in quotes?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.