VBA catch nonull empty field?

Joined
Oct 7, 2013
Messages
1
Reaction score
0
Well, what I ant to do is add a catch exception (try catch) to catch the nonull error before the program, so I can make my own custom error.

What VB does automatically is: If there is nothing in a nonull field, then it will give you a warning a nonull field is empty, and that cant be, then clear all your fields and have you start over

This can happen if you accadently click outside of the next nonull box.

What I want to do is: Catch this nonull error, and give a messagebox saying "This nonull field was left empty" then automatically fill that field with the words "null" so that the other fields wont get cleared and VB stays happy.

I only dont know how to catch that error, would anyone happen to know what that error is called, or how I would catch this specific error with a try catch statement?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top