Hi All

I have been trying to get a grid to change forecolor when someone changes the data in a grid. I have tried several methods and what I have found is the object model is not working as I thought is should. I wrote a litte test program that displayed the object name in the debug window and the following results

dynamicforecolor = checkname(this.name)
What I found was the name returned was the grid name not the column name. What I need to do is to change the color useing a variation of getfldstate(this.controlsource) but I can't do this if I can't get a reference to the column object. I also have complicated this even more by having some columns with a container of two text objects. This would work as well if I could get the column reference.

Any ideas would be appreciated.

Thanks.