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.