All,

I have my appended-records from a CURSOR displayed in a grid. The grid will display all the newly added records before the user choose "Save To Database". In the grid, I need to assign colors to rows which have the same value from a field. Example,

Year CustomerID
1997 A110
1997 A111
1997 A113
1998 B456
1998 B456

where, all rows which contain "1997" will be having "Yellow" and the next group will have "White". Then the 3rd group, will having "Yellow" again.

So, any idea of how to make this effect? Adding code in DynamicBackColor?? How?


Thanks,
Gan