<div>
Instead of using the field directly use:<br />
Replace(fieldname, &quot;'&quot;, &quot;''&quot;)<br />
which replaces a single quote with two.<br />

</div>


Instead of using the field directly use:
Replace(fieldname, "'", "''")
which replaces a single quote with two.


<div>
capricorn1-<br />
<br />
tried the first one and returned - '&quot; &amp;&nbsp;Nz(rst!Debtor, &quot;) &amp;&nbsp;&quot;' in my sql but replaced the double single quote with space and worked a treat.<br />
<br />
Many Thanks 
</div>


capricorn1-

tried the first one and returned - '" & Nz(rst!Debtor, ") & "' in my sql but replaced the double single quote with space and worked a treat.

Many Thanks

<div>
<div class="content wysiwyg-content">
I am opening some data in a recordset and that looping through the data and running a simpe update query using docmd.runsql...my problem arises when I come accross a name that has an apostrophe in it i.e. O'Hara, then I receive a run time error. Does anybody know of a way to handle this?
</div>
</div>


I am opening some data in a recordset and that looping through the data and running a simpe update query using docmd.runsql...my problem arises when I come accross a name that has an apostrophe in it i.e. O'Hara, then I receive a run time error. Does anybody know of a way to handle this?

VBA/Access hanling apostrophe (')?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.