Make sure the grid/column is bound to the table/field. IOW, my code could now look like this:
THISFORM.Grid1.RecordSource = "MyTable"
THISFORM.Grid1.Column1.ControlSource = "MyTable.MyField"
THISFORM.Grid1.Column1.DynamicBackColor = ;
"IIF(MyTable.MyField = 'Red', RGB(255,0,0), RGB(192,192,192))"
Do you have some code/properties you could post? Maybe I'm missing something...
Mark
>That works fine if you use an expression, but I'm trying to tie it to the contents in the field. It's still setting the back color of all the cells in the column to one color, not dynamic based on each record.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.