Search Form - searchjing for text with ' in it

[gueser]

I created a Search form to search some fileds in my main database form. The
only problem is that one of the fields has many entries with apostrophes (').
How do I compensate for that?

 

[Douglas J. Steele]

It depends on how you're doing your searches.

If you're using single quotes as text delimiters in your queries or code,
you need to either change to using double quotes, or else use the Replace
function around the input values to change any occurrance of single quotes
to two consecutive single quotes.