Search to find specific string, or something near it?

[fat controller]

I am trying to allow users to search by for an email address (they will type or paste the email address into a textbox), but I would also like to give them the option to go on and search for email addresses that are similar to rule out any potential mis-spells etc - is this possible with VBA?

 

[CJ_London]

If you mean type in 'smith' and find 'smythe' then it sounds like you need to see if 'simil' will meet your needs

Simil tries to find words which sound 'similar'

google it to find out more and I'm pretty sure there are some simil code examples in the code repository or sample database parts of this forum.

However it won't match 'AC Ltd' and 'Allied Chemicals Ltd' but should match things like Ltd and Limited

 

[fat controller]

After all that, I spoke with the primary users today and they don't want a fuzzy search, they just want a drop down that shows a list of email addresses already stored - so its as easy as a combobox. Thanks anyway