totn Access 2007 VBA Debugging

MS Access 2007: Debug Mode in VBA

This MSAccess tutorial explains the debugging mode in the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

Debug Mode

Now that we know how to set and clear breakpoints in Access 2007, let's take a closer look at the debug mode in VBA.

In our example, we've set our breakpoint and executed the VBA code by clicking on the command button called cmdRunReport.

Microsoft Access

When the breakpoint is reached, Access will display the Microsoft Visual Basic window and highlight the line (in yellow) where the code has been suspended.