Cannot perform Update function when using "Object d'art"

[Pies]

In Access I have a form which has a text string which has a single quote ("Object d'art&quot, this then stops VBA updating a recordset, I know that its the single quote that is a problem anyone got any ideas of how I can update using "object d'art" without removing the single quote?

Pies.

 

[mp9]

You need to use two consecutive single quotes instead of one, i.e:

UPDATE tblYourTable 
SET YourField = 'Object d

''

art'
WHERE ID.Field = 1;

Note that the bit in bold, above, is two single quotes, not a double quote.

http://www22.brinkster.com/accessory/