Dealing with Apostrophes in my data -- Access 2007 VBA

[LA Lawyer]

I have some programming that includes using a contact's name which sometimes
includes an apostrophe, like O'Keefe, O'Reilly, etc. This is causing me
grief when it crashes otherwise perfect coding.

How can I deal with this issue?

 

[fredg]

I have some programming that includes using a contact's name which sometimes
includes an apostrophe, like O'Keefe, O'Reilly, etc. This is causing me
grief when it crashes otherwise perfect coding.

How can I deal with this issue?

The usual fix is to use """" instead of "'".
How about posting the current code that is causing the error so we can
work with what you're using.

 

[John W. Vinson]

I have some programming that includes using a contact's name which sometimes
includes an apostrophe, like O'Keefe, O'Reilly, etc. This is causing me
grief when it crashes otherwise perfect coding.

How can I deal with this issue?

Either use " to delimit your text strings and criteria, or double up the
apostrophe. It might help if you would post the relevant part of your code.