I came across an unusual problem today. I have code to add the contents of a form to a table. It works great, with one exception. If I end the entry, in a text field, with a single quotation mark (') it throws a Run-Time Error 3075. This is not a big deal but if a user accidently hits the (') button at the end of their entry (and I'm sure it is bound to happen) it will cause this error. I will add this to my error handling but I didn't know if anyone else has come across this and how they handled it... or maybe why it does this. BTW.. I am using Access 2016.
Posted by: John Viescas <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (2)|