Hello,

I have a user form, which of course, takes-in user's info. If a user enters in apostrophe in the string, (i.e. Smith's Hardware) the application throws an error. However, if the user enters (Smiths Hardware) the string is inserted into the DB fine.

My question is how do I insert these apostrophes into my Database?

Thanks in advance,

MGR

Using a replace method, such as:

Dim strText As String = "Smith's Hardware"
strSQL &= "... set Name = '" & strText.Replace("'", "''") & "', ...

Brian

Ok Brian,

Thanks I will give it a try.

Mark