The only example I have found about this problem uses DynamicBackColor and a test on RECNO().

This technique does not work if there is a deleted record that is not displayed, or if the order in which rows are displayed is changed.

The only way to get the expected result, no matter how the records are displayed is to use the row number. However, I cannot find any property that would give the row number except only for the active one. Using ActiveRow does not work.

Does anybody know how to obtain the correct result?