Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DynamicBackColor problems
Message
From
08/12/1997 09:51:14
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00064079
Message ID:
00064434
Views:
52
>>>>>>Could someone tell me how to use a character value with this statement:
>>>>>>
>>>>>>thisform.Grid1.SetAll("DynamicBackColor", ;
>>>>>> "IIF thisform.grid1.ctime.combo1.value=1300, RGB(255,255,255) ;
>>>>>> , RGB(0,255,0))", "Column") && Alternate white and green records
>>>>>>
>>>>>>The value is actually character "1300", but putting in quotes obviously causes an error (quotes within quotes). How do I put quotes in?
>>>>>
>>>>>try this
>>>>>"IIF thisform.grid1.ctime.combo1.value='1300', RGB(255,255,255) ;
>>>>> , RGB(0,255,0))", "Column") && Alternate white and green records
>>>>>
>>>>>HTH
>>>>>Jeff
>>>>
>>>>Ya'll are both leaving out the open parentheses required for an implicit if...
>>>
>>>Erik, Jeff:
>>>
>>>I tried...
>>>
>>>thisform.Grid1.SetAll("DynamicBackColor", ;
>>> "IIF thisform.grid1.ctime.combo1.value='0800', RGB(255,255,255) ;
>>> , RGB(0,255,0))", "Column")
>>>
>>>I get no errors, but it simply does not change the colour of any grid lines. Where should I put the brackets Erik? This code is copied out of the VFP help from an example that changes every second line to green.
>>>
>>>Any other ideas why this might not work?
>>
>>I would inquire credibility of using 'thisform.grid1.ctime.combo1.value' as dynamic identifier of the same grid. It looks too suspicious to work somehow.
>
>Ed,
>
>What would you suggest? I want to change the row colour based on the values in that column.

You should check field value from Grid.Recordsource
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform