Apostrophes in table data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access2002, if I want to allow apostrophies in table data, how can I code
my VBA to allow for that in the "recset.open" command? Sorry to ask such a
n00b question, but it's never come up for me before now.

Thanks for any insight in how to do this.
 
In Access2002, if I want to allow apostrophies in table data, how can I code
my VBA to allow for that in the "recset.open" command? Sorry to ask such a
n00b question, but it's never come up for me before now.

Thanks for any insight in how to do this.
Click to expand...

There's nothing particular about the Open method that would be impacted by
having apostrophes in your field data. What specific problem are you having?

The only concern would be that any query criteria need to be delimited by "
rather than by '.


John W. Vinson [MVP]
 
Back
Top