[AccessD] Dealing with single quotes and double quotes at the sametime

Here's an example

strText = "1" & chr$(39) & " 5" & chr$(34)

In this case strText would return - 1' 5"

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
Sent: Wednesday, November 01, 2006 2:37 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Dealing with single quotes and double quotes at the
sametime

Hello,

If I construct a string in VBA that contains the following string:
1' 5"

How could I update a field using DoCmd.RunSQL?
I know how to handle this if the string only contains a single quote OR
a double quote but not if the string contains both.

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com