Kamis, 18 Februari 2016

[MS_AccessPros] Runtime Error 3075 due to field contents


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: jennylou68@verizon.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)



Tidak ada komentar:

Posting Komentar