Hi Eric,

Setting the DynamicBackColor to "mytable.ccolor" does work: I created a sample that worked before I sent you the solution. By any chance are you going into the property sheet and putting the following including quotes into the DynamicBackColor property:

"mytable.ccolor"

If that is true, then you are not doing it correctly. If you fill in this property in the property sheet, you should only put the following:

mytable.ccolor

Does this work for you?

Rick

>Ok, here's the solution to a colored cell in a grid based on a color value in a field. Putting the field reference in DynamicBackColor doesn't work (i.e., "mytable.ccolor") however if you put in a conditional statement
> ="iif( empty( mytable.ccolor ), rgb( 0, 0, 0), mytable.ccolor )"
>it works. Don't know why, but it works.