Microsoft Access Office VB VBA Help and Examples

Finding Data Entry Typos

The link below contains a database with one form. This form will help you find one character data entry typos in the same field. It's another in progress thing so it's a little slow. But what it does can save a lot of manual searching.

If you have a field that contains the following records

Anne  Annte Ane Anme 

they will all be returned by this form  as typos of each other. Just import the form into your database and select a table and field and run.

Please note it could take quite a while if the recordset is huge.

TyposChecker.mdb 140Kb Version 1.0

The code and application content of this site is copyright of Smiley I.T. and as such reproduction in any form which is for commercial use requires the permission of the Webmaster. Any use of this code for non-commercial use only requires a link or comment back to the original page you took the code from.