Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

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...
0
JBHansen
Asked:
JBHansen
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now