text with odd characters

[vicsaccess]

i have an unbound entry form with a SQL INSERT on a command button. works great till i tested it with the word "don't". didn't like the apostrophe so i changed from ,'" & me.txtdetail.value & "', to """ & me.txtdetail.value & """ and it works great again but just for giggles i then tried putting quote marks in my text box with a word and it didn't like that. i'm sure that someone entering information into this will try to use some unusual characters since it is a description of the incident entry box. how is the best way to handle this?

[orange]

The subject of what you are dealing with is called escaping unwanted characters.

Here is a link to assist.
http://stackoverflow.com/questions/1...ion-and-implem


Good luck.

[June7]

Apostrophe and quote marks have special purpose in SQL. They are text delimiters that define the begin and end of text strings. As orange's link demonstrates, must 'escape' the special characters so SQL will process them as literal text. Doubling a special character does this. The Replace function will accomplish this without actually changing the raw saved data.

[vicsaccess]

thanks orange. oh boy, more reading