title: Use Single Quote As Part Of Replace Statement In VBA
body: <p>I am needing to replace a single quote with nothing, using VBA.  I put together this syntax, but it is reading my single quote as a comment indicator.  I also tried to put two single quotes but that did not work either.</p>
  
  <p>What is the proper way to run this replace statement in access 2013 VBA</p>
  
  <pre><code>DoCmd.RunSQL "update spreadsheetimport set userinput = replace(userinput, "'", "");"
  </code></pre>