[AccessD] Dealing with single quotes and double quotes at the same time

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