Solved

MS Access Can I capture Cancel click in InputBox?

Posted on 2010-09-23
1
320 Views
Last Modified: 2013-11-27
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
Comment
Question by:JBHansen
1 Comment
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 50 total points
Comment Utility
"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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now