You can either check the string before inserting and escape the "bad"
characters, or use ADO and command objects along with an Insert Query.  The
command objects will handle the "bad" characters for you automagically.

-- Tomm

> -----Original Message-----
> From: Lloyd Levine [mailto:levinll@m...]
> Sent: Wednesday, October 03, 2001 5:08 PM
> To: sql language
> Subject: [sql_language] Inserting text into a field that contains commas
> and apostrophes
>
>
> I have a VB front end with an Access back end. I want to give my
> users the
> ability to enter text that may have commas and apostrophes. Is this
> possible ?
>
> Currently if they use either a comma or an apostrophe the app
> generates an
> error.