Forum Discussion

gcalle's avatar
gcalle
Copper Contributor
Apr 11, 2025

BUG REPORT MS ACCESS: F5 Key in VBA Editor Behaves Like F8 – Code Runs Line by Line After Breakpoint

Issue Summary:

In the VBA Editor (VBE) of Microsoft Access (Microsoft 365, 32-bit), I'm experiencing a critical issue during debugging:

When I enter break mode (e.g., hit a breakpoint) and press F5 (or click “Continue”), the code does not resume execution normally — instead, it continues line by line, exactly as if I were pressing F8. This completely breaks normal debugging flow.

Things I Tried (none fixed the issue):

  • Compact and Repair database.
  • Ran Access with the /decompile switch.
  • Created new, clean databases.
  • Reinstalled Office 365 completely.
  • Ran both Quick Repair and Online Repair.
  • Used Office Deployment Tool to downgrade to older versions.
  • Cleared .exd, vbaProject.bin, and temp VBA cache files.
  • Verified it's not a keyboard or hardware issue.
  • Disabled OneDrive sync (though my Documents folder is still redirected).
  • Checked VBE-related DLLs (VBE7.DLL), and user registry entries.
  • Same result on other PCs in my workplace.

What Did Work (But Not a Practical Solution):

I created a new Windows user account, re-ran Access there, and F5 worked normally again, even using the same Access application where the issue originally occurred.

This confirmed that the bug is profile-specific, likely tied to a corrupted configuration or setting in the original Windows user environment.

Why That’s a Problem:

Creating a new Windows profile is not viable in a production/development environment:

  • I use licensed OCX controls (Viscom) tied to my current user profile — reactivation would require additional purchases.
  • Other tools  are already configured.
  • Recreating the full environment is costly and time-consuming.

🧠 How I Discovered This:

When I purchased a new laptop and did a clean install of Windows and Office, the issue did not occur at all, even when running the same Access database file. That’s when I realized it was tied to something in the Windows user profile.

With help from ChatGPT, I identified that the issue is likely due to corrupt user-level configuration of the VBA editor, which is not easily reset or exposed to users.

🔎 Possible Causes:

  • Corrupt configuration in %APPDATA%, registry, or synced files.
  • VBA/VBE state incorrectly cached.
  • Debugger logic affected by user-specific flags or crash residue.

📢 Request to Microsoft:

Please consider providing:

  • A tool or command to reset all VBE/VBA user settings (without creating a new user account).
  • Documentation on which files or registry keys may affect debugging behavior.
  • An investigation into why F5 acts like F8 and what triggers this silent corruption.

Thanks four your help

No RepliesBe the first to reply

Resources