Inserting apostrophes into an Access Dataabase
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,