Dealing with Apostrophes in my data -- Access 2007 VBA

  • Thread starter Thread starter LA Lawyer
  • Start date Start date
L

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?
 
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?
Click to expand...

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.
 
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?
Click to expand...

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