I have a search form that searches the database. There is just 1 text box and it searches for SSN, Last Name, First Name, Record ID, etc. The trouble I am having is the system saves SSN's like xxxxxxxxx, vs xxx-xx-xxxx. Unfortunately different people enter them differently by habit so when someone uses the search field with xxx-xx-xxxx it does not pull them up because the -'s are not stored. Is there a way to have it exclude these when doing the SSN search so it will accept both ways of entering? Below is the code for the After Update event:
Code:
[SSN] Like "*" & [Forms]![frmRecordsSearch]![SearchFieldTxt] & "*" Or [LastName] Like "*" & [Forms]![frmRecordsSearch]![SearchFieldTxt] & "*" Or [FirstName] Like "*" & [Forms]![frmRecordsSearch]![SearchFieldTxt] & "*"