>The Dynamic properties are avaluated on grid level so This in the expresion refers ro the grid not a column.


hmmm, how can i then change the color of each individual cell depending on its value? is this possible with DynamicBackColor?


>>
>>3 years ago (or so) i had problems with that DynamicBackColor thing. doesn't seem i have learned anything in that time :-(
>>
>>the foloowing code causes the grid to error with "Expression is invalid. use a valid expr for Dyn..."
>>
>>the firld in the table is a numeric field and the columnCount=-1 in the grid to automaticly add the columns at run-time. the SetAll Command is issued after the grid receives ControlSource="MyTable"
>>
>>

>>THIS._grid1.SETALL(;
>>	"DyNamicBackColor", ;
>>	"IIF(eval(This.ControlSource)<10,RGB(0,255,255),
>IIF(BETWEEN(eval(This.ControlSource),10,20),RGB(0,255,0),RGB(255,0,0)))", ;
>>	"Column")
>>