Parameter search in a text field

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

I need to search a memo field for the presence of certain text. I want to
have a paramater search come up in which I can enter the text Im looking for
as it will change many times. Im using this now in the criteria box in a
query...

Like "*" & [Enter text to find] & "*"

BUT...that seems to be case sensitive. Entering william gets no results.
Entering William does find William. I want the query to find William if I
enter will, Will, william, wi. I need a match on anything regarless of
length or case. If possible.

Can anyone show me what needs to be in that criteria box?
 
WHERE is the data stored? Access is not case sensitive so if you are
using a JET database (.mdb or .mde) then the query should work.

If the data is in an excel sheet or other database, it is possible that
the search is case sensitive. In that case you may need to force the
search to change the data to upper (or lower) case and the criteria to
upper (or lower) case.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top