I have an update form which updates an Access database, but when I enter a value with an aposrophe (') it breaks it; as the next time I try to use the <b>update form </b>it doesn't work?

Any help would be great <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks

Paul

Replace ' with ''. Something like:
<pre id=code><font face=courier size=2 id=code>Replace(Something, "'", "''"</font id=code></pre id=code>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I have an update form which updates an Access database, but when I enter a value with an aposrophe (') it breaks it; as the next time I try to use the <b>update form </b>it doesn't work?

Any help would be great <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks

Paul
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic
www.farcic.com
TalkZone Manager

Edited by - vfarcic on 11 Aug 2002 19:14:24