>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?
This one alternates colors based upon MOD(), and also does so based upon a field value, so you can trim it down as needed.
IIF(BACKUPTYPE = 'B', IIF(MOD(RECNO(), 2) = 1, RGB(215,252,255), RGB(183,250,255)), IIF(MOD(RECNO(), 2) = 1, RGB(253,254,194), RGB(253,255,176)))