Access - Variable calling a DB record field that has quotation marks in the text
Posted on 2014-12-09
I have a bit of code that sets a record field as a String. Then that variable is used in a VB code to send an Email or Text message.
That records field has Quotations in the field.... SOOOO when the variable is set using a Dim strABC as string and then the code that uses it is .Subject = "Info From: " & strABC & " " & lnginfo it is interpreting the info as quotations in quotations.
Is there a way that the Dim'ed string can have quotations that the code will use?