VBA code to capture keypress

[JB510]

I am running a code which takes a long time to process.
I sometimes want to [Ctrl][Break] to temporarily halt and check the code then continue but it gets so busy, the [Ctrl][Break] does not respond.

Back in by C64 basic days, there used to be a GET statement were the code would not stop like an Inputbox, it would just capture the a keypress if the key is pressed down.
Is there such a command in VBA for MS Access?
I could use this to trigger a temporary halt in my code.

[ranman256]

i dont think access will give up the time to get the keypress.

[pbaldy]

Won't including DoEvents in the code let Access check for the keypress?

[KNicholson]

Once a long running query is churning, I sometimes use TaskManager to stop it.
I know it is not best practice but my data is in SQL Server and my databases are always backed up.
If a query takes too long to process, the processing needs to be moved to SQL Server.
I mess up sometimes when developing a run a query without a filter and get hosed.