double quotes in the SQL string

[Souris]

I use DAO.QueryDef and pass parameter to update or insert in to my table.

The query failed if user enter double quote in the text which Access thinks
it is invalid SQL statement.

Are ther any way to workaround to let user enter double quotes in the text?


Your information is great apreciated,

 

[J_Goddard via AccessMonster.com]

If the user enters the text in a form, try replacing all the double-quotes
with double double-quotes (!) after the user enters the string (use the After
Update event of the textbox):

MyString = replace(me!txtstring, chr(34), chr(34) & chr(34) )

and then use MyString in the QueryDef.

John

 

[Douglas J. Steele]

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