I am having a problem when submitting data from a text box into a database. The problem comes in when I use an apostarphe. Can anyone help in how to overcome this problem.

My thought is to search the data for the apostraphe and replace it with a Chr(??) and then submit it. How do I do this, if it is the correct method of doing so.

Any help is greatly appreciated.

Thanks