<div>
perfect - I didn't know it would be as simple as to be able to do it inline like that. Thanks!
</div>


perfect - I didn't know it would be as simple as to be able to do it inline like that. Thanks!

<div>
<div class="content wysiwyg-content">
using this:<br />
<br />
strSubj = DLookup(&quot;ActionLogAssignme<wbr />ntChangeEm<wbr />ailSubject<wbr />&quot;, &quot;tblEmailSettings&quot;, &quot;SettingsID = 1&quot;) &amp;&nbsp;Me.Call &amp;&nbsp;&quot; - &quot;&nbsp;&amp; Me.Customer &amp;&nbsp;&quot; - Closed: &quot;&nbsp;&amp; Me.Closed<br />
<br />
me.customer may occasionally contain a single quote '<br />
<br />
(IE, &quot;Our Company Name's&quot;)<br />
<br />
What's the best way to tackle this?
</div>
</div>


using this:

strSubj = DLookup("ActionLogAssignmentChangeEmailSubject", "tblEmailSettings", "SettingsID = 1") & Me.Call & " - " & Me.Customer & " - Closed: " & Me.Closed

me.customer may occasionally contain a single quote '

(IE, "Our Company Name's")

What's the best way to tackle this?

ms access vba strip single quote from string

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.