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

Dynamicforecolor, backcolor, etc are properties of the column, not of the grid. If you want to reference a property of the grid, you must use this.parent.property. Using this.controlsource in the dynamicforecolor would work because control source is also a property of the column, but recordsource is a property of the grid, so referencing it would also require this.parent. I suspect that the reason that it worked for Bruce at the form level was because he used thisform. I am interested to see if this solves it.