Fix VBA Breakpoints Not Working in Microsoft Access 2019
Question details
The user needs Access 2019 VBA execution to stop at a breakpoint.

- Product
- Microsoft Access 2019
- Device & OS
- not provided
- Scenario
- The user is debugging a VBA procedure triggered by an Access event.
- Observed behavior
- A breakpoint appears in the VBA editor, but execution does not stop at it.
Open the database and identify the form, control, or event that should run the procedure. If Access shows a security warning for a database you trust, select Enable Content so its VBA code can run.
Verify the Event and Recreate the VBA Breakpoint
Use this first to check that the expected procedure and executable line are being reached.
Open the form or report in Design View, select the relevant object, and open Property Sheet > Event. Check that the intended event is set to [Event Procedure], then select the ellipsis button to open its code.
In the Visual Basic Editor, click an executable statement in the procedure and press F9 to toggle its breakpoint off and on. Avoid setting it on a declaration, comment, or blank line.
Return to Access and perform the action that triggers the event. If execution stops at the breakpoint, press F8 to step through the code; if it does not, check whether the event or a conditional branch prevents that line from running.

Compile the Access VBA Project
Compile the project to find code errors that may interfere with debugging.
Decompile and Repair the Access Database
If the event path and breakpoint are correct but debugging still fails, rebuild the database's compiled VBA state.
Use WPS Office for Everyday Office Documents
WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format support make it easy to move everyday files. It does not repair Access or run Access databases and VBA procedures.

Frequently Asked Questions
Why does Access skip my VBA breakpoint?
The event may call a different procedure, or execution may not reach the selected line. Check the object's Property Sheet > Event, then set the breakpoint on an executable statement in the procedure that actually runs.
How do I compile VBA in Access 2019?
Press Alt+F11 to open the Visual Basic Editor, then select Debug > Compile VBAProject. Correct any reported errors and compile again.
Can a security warning prevent my VBA code from running?
Yes. If Access blocks active content, VBA may not run. For a database you trust, select Enable Content on the security warning and try the event again.
What does decompiling an Access database do?
Opening an editable database with the /decompile switch discards its compiled VBA state so the project can be compiled again. Work on a copy, then compact and repair it and use Debug > Compile VBAProject.




