>>>>I’m setting background colors in a grid so that some rows are a light green, and the rest are the normal white. It works fine on my machine (with an old simple screen card), but fails on my user’s newer machines. Here’s the code from the form’s Init():
>>>>

>>>>thisform.grdTheGarment.SetAll( ;
>>>>  "DynamicBackColor",;
>>>>  "iif(cType = 'L', rgb(225,255,226), rgb(255,255,255))",;
>>>>  "Column")
>>>>

>>>>The error message is in an Ok/Cancel messagebox, and says:
>>>>Expression is invalid. Use a valid
>>>>expression for DYNAMICBACKCOLOR
>>>>property.
>>>>
>>>>My user clicks on Ok 3 times, the messagebox disappears, and the form displays, but with a reported different green in the grid than requested. A separate textbox on the same form uses the same requested rgb(225,255,226) light green too, but shows the color correctly.
>>>>
>>>>Any thoughts?
>>>
>>>What is cType?
>>
>>lv_LocGarDef is the RecordSource for the grid. cType (lv_LocGarDef.cType) is one of the fields in the the grid's RecordSource.
>
>Then use the full qualified field name:
>

>thisform.grdTheGarment.SetAll([DynamicBackColor], [iif(lv_LocGarDef.cType = 'L', RGB(225,255,226), RGB(255,255,255))],[Column])
>

It works the same (correct) way on my machine using either cType or lv_LocGarDef.cType so I haven't tried lv_LocGarDef.cType on the user machine (yet). It is now one of a few things that I can try. I'm also going to try some different "close" but diferent colors that are, say, multiples of 8 for the intermediate positions like RGB(224,255,224) instead of the curent RGB(225,255,226), and hopefully more likely to "exist" for me in that machine's color vocabulary. It feels unlikely that this will work, but I'll be trying it too.