Finding " in strings

[colin.marker]

Hello,

I am writing a vba program that uses many SQL calls to access. I am
having a problem with people using " instead of putting inches. I can
not figure out how I can trap this in any strings because everything I
try VB interperates it. My problem is when I try to put the strings
like '5" plug" into an SQL querry it messes it up.

Could someone please help me clean up the strings to remove quotes (")
and commas (,) ?
I got it to remove commas by using string = replace(string,",","-")
but I cant do the same with quotes.

 

[Douglas J. Steele]

replace(string,""""," in.")

or

replace(string, Chr(34), " in.")

However, to learn how to keep "5" plug" and use it in SQL, see my May, 2004
"Access Answers" column in Pinnacle Publication's "Smart Access". You can
download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html