double quotes in the SQL string

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
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
 
Back
Top