Hello,
I've been encountering this issue and have attempted many different things and have not had success. Here's my problem. I do not allow NULL values to be entered into my SQL database (Zero-length strings are used instead). So I have a bound form containing data. If the data is cleared from a bound field and a user attempts to save the form, the following error locks everything up.
Start with this:
After clearing the data:
The following error locks up.
I know why this happens. What I need to figure out is how to replace a NULL submission to the database with a zero-string. I've tried using Lost Focus and Before Update and have not had any success with the methods I've constantly tried.
Help would be appreciated!
Thanks much.