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?
 
Back
Top