Ignore certain words in textbox

[Atthe]

Hi All,

I have a search text box in my forms and frequently have end users enter irrelevant information into the text whilst trying to search which results in no matches found.

Can someone help with some code to remove certain words(That I can specify from within the code) from the text box (Example the end users searches 'Apple 2345' I need the code to remove Apples and leave me with '2345'

Thanks

 

[theDBguy]

Hi. You could use the Replace() function. For example:

Replace([Textbox], "apple", "")

 

[arnelgp]

what "specifics" do you need to remove? the text and leave only the number?

 

[MajP]

Maybe something like this search feature would work to give total flexibility.
The user can type in "Apple 1234" then have the option to search "Apple", "1234", "Apple or 1234", "Apple and 1234"

Solved - Search all words in field against all words in another field

I kind of disagree in a db because you can probably build a much better search using sql Like search. This is based on a pretty thorough demonstration of a couple of interfaces using (Soundex, Simil, Levenshtein, and just find as you type) Like?? Like won't find similarities in strings with...

www.access-programmers.co.uk

 

[jdraw]

You could have an Ignore list for those words/strings you do not want to be in the search criteria.