Find problems in a macro by single stepping through it

Microsoft Office Access 2003

  • Open the macro.

    ShowHow?

    1. In the Database window, click Macros Button image under Objects.
    2. Click the name of the macro you want to open.
    3. Click the Design button on the Database window toolbar.
  • Click Single Step Button image on the toolbar.

  • Click Run Button image on the toolbar.
  • Do one of the following:

    To carry out the action shown in the Macro Single Step dialog box, click Step.

    To stop the macro and close the dialog box, click Halt.

    To turn off single stepping and run the remainder of the macro, click Continue.

  • ShowTip

    You can also stop a macro while it's running and then single step through it by pressing CTRL+BREAK.