VBA & Macro Problems

Fix VBA Breakpoints Not Working in Microsoft Access 2019

Phi Hung VoPhi Hung Vo Nov 18, 2026 869 views

Question details

The user needs Access 2019 VBA execution to stop at a breakpoint.

Fix VBA Breakpoints Not Working in Microsoft Access 2019
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.
Before you start

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.

Solution 1Recommended

Verify the Event and Recreate the VBA Breakpoint

Use this first to check that the expected procedure and executable line are being reached.

1
Check the event binding

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.

2
Set an executable breakpoint

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.

3
Trigger and trace the code

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.

Verify the Event and Recreate the VBA Breakpoint
If the event uses a macro: An event can be bound to a macro or expression instead of a VBA event procedure. Check its Event property before assuming the displayed VBA procedure is called.
Free Microsoft Office alternative

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.

Free, lightweight tools with a familiar Office-style interfaceCompatible with Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXOpen and edit everyday Office files while troubleshooting Access separately
microsoft office alternative - wps office

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.