accent insensitive query on access

[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.

 

[Douglas J. Steele]

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.