Equivalent of Excel's EnableCancelKey in Access?
Posted on 2013-01-05
I want the user of an Access database to be able to interrupt and exit procedures that involve long loops.
I could trap the KeyDown event of <Escape> so that it changes the value of a global variable whose value gets checked within the loop and so permits code execution to pass out of it, but that would slow down the procedure even further.
Does Access have an equivalent of Excel's Application.EnableCancelKey property (set to xlErrorHandler would do the trick), or does anyone have their own improvised equivalent?