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