MS Access Can I capture Cancel click in InputBox?

Is it possible to capture the cancel button being clicked on an InputBox?

I've read in a few places that you just have to check for a blank or zero value, but if that's the case, what purpose does the Cancel button serve?

In my case, zeroes and blank values are allowed and I want the cancel button to let the user quit the function. I know I could build my own form or even have a follow-up when zero or blank is entered to ask whether they want to actually cancel or continue, but I'm hoping I can take care of it all in one step...
JBHansenAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
"but if that's the case, what purpose does the Cancel button serve?"
It in fact creates the 'blank or zero value, ' ... aka Empty String   ""

mx
0
All Courses

From novice to tech pro — start learning today.