Somebody told me once how to make cells in a grid that have changed be a different color, but I cannot find where I wrote that down.

This is what I tried:

FOR i = 1 TO THIS.columncount
   THIS.COLUMNS[i].dynamicforecolor = ;
      "IIF CURVAL(EVAL(THIS.controlsource)) <> OLDVAL(EVAL(THIS.controlsource)), ;
       RGB(255,0,0), RGB(0,0,0))"
ENDFOR

I also tried it without the EVAL, and with an & instead. It doesn't give an error; it just doesn't work.

As I'm typing this, I just got a clue. I'm using a view, so the controlsource is a field in the view, not the table. Is that why?

How do I make this work with a view?

Thanks,

-Michelle