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