Hi Sergey,
Better...
This is equal to CurrentControl/DynamicCurrentControl if is cell active
This is equal to Grid if is not cell active
MartinJ
>The Dynamic properties are avaluated on grid level so This in the expresion refers ro the grid not a column.
>>
>>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")
>>