Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Colouring a row on a grid
Message
From
01/12/1997 13:35:03
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00062613
Message ID:
00063088
Views:
39
>>>>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?

All IIF, it should be character.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform