I want to debug a macro that is initiated from a form event. I’m setting a breakpoint in the macro itself and nothing happens. A post on here suggests leaving the macro window Open which I’ve done but I still can’t see that it has ‘hit’ the breakpoint. In access the VBA line would be highlighted for me to step through. This is not happening.
My OS is windows 10
Version: 7.0.5.2 (x64)
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
I’m using HSql
Hello,
Not certain as to where your problem lies. Various ways to set a breakpoint. Here is one:
You can also set a watch:
The IDE should remain open. If closed the breakpoint will clear. Also, when the break occurs, the cursor will be positioned on the current break (can have multiple) and the icon will change:
For further information please see → Fast Macro code, how to interrupt, stop?
and
perfect. I was not aware of enable watch which is different from what I am used to. it also shows as a pair of spectacles in my environment/version
thank you
Apologies I got the wrong gist with enable watch. The main thing is you have to leave the window open. I wasn’t so now works great. Thanks.