accent insensitive query on access

  • Thread starter Thread starter Yanndc
  • Start date Start date
Y

Yanndc

Hello Gurus...

Is someone got an idea on how to do a accent insensitive
search on a access database?

My client wants english user to retreive records
containing accent even if they enter an "e" instead of
an "é". (e acute).

Thanks for your help.
 
One approach would be to create a function that converts the accented
characters to unaccented characters. Create a computed field in your query
that uses that function, and check against it, rather than the actual field.
To ensure that non-English users get the same results, you'll probably want
to use the function against what the user keys in as a search as well.


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Hello Gurus...

Is someone got an idea on how to do a accent insensitive
search on a access database?

My client wants english user to retreive records
containing accent even if they enter an "e" instead of
an "é". (e acute).

Thanks for your help.
 
Back
Top