.DYNAMICBACKCOLOR = "IIF(MOD(RECNO(), 2) = 0, RGB(225,225,225), RGB(0,255,64))"I would like to get the same results based on the index that is currently in use. If I click on a header that has the ability to order the results, I would like to still see the alternating colors rather than 3 of this color and 2 of that color. RECNO() does not work in this case because they will be all jumbled based on the "SET ORDER" of the table.
.DYNAMICBACKCOLOR = "IIF(MOD(TAG???(RECNO()), 2) = 0, RGB(225,225,225), RGB(0,255,64))"Does anyone have any ideas?