Kim,

 

This is not an editor related issue.

 

The proper string delimiter in SQL is the single apostrophe.

 

To indicate that a string itself contains a single apostrophe, one must double it up. It is the responsibility of the front-end application to present queries to Access/SQL so that Access/SQL can parse them.

 

So your front-end application has to have an extra step to take the search phrase from the user, scan it for single apostrophe and insert an extra apostrophe before handling it over to Access/SQL.

When building your SQL Query, replace all apostrophes with double
apostrophes:

replace(variabletoreplace, "'", "''")

This lets Access/SQL know that you mean the apostrophe to be in the string
and not the end of that data field.