>>>I'd like to make it more generic by using a variable to enter the coloring but I always get an "Invalid expression in the Dynamic...."
>>>The variable is a property of the grid and the something = something is properly evaluated as they are properties of the grid too.
>>>
>>>THIS.gnForeColor = some valid color value
>>>
>>>Example: IIF(something = something, THIS.gnForeColor, ........
>>>
>>These variables seem to need a wider scope...try it as a form property.
>
>Hi Bruce,
>
>I'll give that a try but why would the evaluated expression understand "THIS" being in the grid but not the color properties? IIF(RECNO(THIS.RecordSource) = THIS.gnLastRec, color, color) - The statement understands THIS.RecordSource and THIS.gnLastRec just fine, it just doesn't do the colors unless I have the RGB funtion included.
>

Good question...I had trouble with it too...all I'm sure of is that it works for me as a form property (I also have "gnLastRec" at the form level, that wouldn't work for me locally. I've only had success with everything at the form scope level...