BUG: Find and Replace Access 2016 and 2010
There appears to be a bug within Microsoft Access on at least 2016 and 2010 release versions.
When doing a Find and Replace on a Field, the first record is acted upon twice in certain circumstances.
When Highlighting the Entire Column or just one cell, the first cell of the field, or the one cell chosen gets acted upon twice by the find and replace after hitting Replace all.
I can provide screen shots upon request, but you should be able to reproduce this easily using
and doing a find On 1 and replace with 1L
you end up with
If you highlight the column or the cell singular. It does not occur if you enter the cell.
Thanks for reporting.
We will add this bug report to our backlog and see that it is prioritized and handled.
In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.