Quote marks in Text problem

[Richard]

I have a text field that I use a SQL update command on. If I type a quote
mark like in Don't or wouldn't I get a SQL error showing a problem in the
text field. Take the quote mark out so it now reads dont or wouldnt and
everything is ok. I have been playing around with the idea of reading the
line with the Mid(Me.field, n,1) but I would hope there is a much better way
to deal with this problem.

Any ideas or help in this would be greatly appreciated.

Richard

 

[Timothy C. Doherty]

Single quote character in a SQL string should be represented by two single
quotes... wouldn't = wouldn''t, don't = don''t