>The Dynamic properties are avaluated on grid level so This in the expresion refers ro the grid not a column.
Hello Sergey
Cetin's reply is the one i ended up using. i like his approach of using a UDF (i am using that in a different grid as well). it somehow never occured to me to fill the DynamicBackColor seperatly for each column, and therefor beeing able to query each columns controlsource.
oh well, hope it's not monday <s>
Thanks for your help!
>>
>>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")
>>