[AccessD] Text problem in runSQL

This takes care of apostrophes and quotes within the text:
... tblSoumissionDetail.Description = " & """" & txt & """"

That's how I always do it.

Regards
Steve


--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Friday, April 17, 2009 5:21 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Text problem in runSQL

> Annie"
>
> If you have apostrophes in your text then instead of using apostrophes to
> delimit the string use double quotes - "".
>
> So tblSoumissionDetail.Description = '" & txt & "'
>
> Becomes tblSoumissionDetail.Description = """ & txt & """
>
> Of course, if you then encounter a string with quotes in it, like
> representing inches, you've got the opposite problem.
>