Is there a way to set the DynamicBackColor of a grid's rows so that the row colors alternate (green,white,green,white....etc) without relying on the recno() as the grid wizard does? I need to order the table in my grid and when I do this the current setting of IIF(MOD(RECNO(),2)=1,RGB(255,255,255),RGB(192,220,192)) for the DynamicBackColor throws everything off. I get green,green,green,white,white...etc etc etc.

TIA