>I have a grid with recordsource coming from a sql statement into a table. I'm trying to get dynamicbackcolor to alternate colors with a mod statement but the colors don't alternate. what is the best way to do this?

The example in the help file for DynamicBackColor does just this. Take a look.