In the Action Catalog on the right side of the macro design window, search for SingleStep. Use the following procedure to add the SingleStep macro action to your macro: To begin single stepping at a specific point in your macro, you can add the SingleStep macro action to your macro at the point where you want single stepping to begin. To begin single stepping while a macro is running, press CTRL+BREAK. To turn off single stepping and run the remainder of the macro, click Continue. To stop the macro and close the dialog box, click Stop All Macros. To carry out the action shown in the Macro Single Step dialog box, click Step. A zero in the Error Number box means no error has occurred. This dialog box displays information about the macro and the macro action, as well as the error number.
The Macro Single Step dialog box appears. If the macro is a new or edited macro, you will be prompted to save the macro before you can run it.
On the Design tab, in the Tools group, click Single Step.Ĭlick Run. Right-click the macro in the Navigation Pane, and then click Design View. Lessīy single stepping through a macro, you can observe the flow of the macro and the results of each action, and isolate any action that causes an error or produces unwanted results. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.