>I cam back to revisit this one after my last reply. So we don't make this thread any longer then it has to be can you answer the following:
>
>Are you trying to do this through Visual Basic or through Access VBA (what versions also)?
>What is your backend? SQL or Access? What version?
>Give an example of exactly what you are taking in as the input, and how you want it stored in the database. e.g. User input is
>
>This is just a "little" out of hand.
>
>The above is quite differne then
>
>This is just a 'little' out of hand.
>
>Answering these questions should make things clearer.

I am writing this in VB in a module in Access '97 so I suppose it is VBA? The whole thing is in Access '97 and driving me up a wall. I'm just trying to save a string like:

A dog is a man's "best" friend

into an Access '97 table using a SQL insert command in a code module. Thanks for looking into this for me!

Sally