DisplayHourglassPointer Macro Action

Office 2013 and later

Last modified: July 28, 2015

Applies to: Access 2013 | Office 2013

You can use the DisplayHourglassPointer action to change the mouse pointer to an image of an hourglass (or another icon you've chosen) while a macro is running. This action can provide a visual indication that the macro is running. This is especially useful when a macro action or the macro itself takes a long time to run.

The DisplayHourglassPointer action has the following argument.

Action argument

Description

Hourglass On

Click Yes (display the icon) or No (display the normal mouse pointer) in the Hourglass On box in the Action Arguments section of the Macro Builder pane. The default is Yes.

You often use this action if you have turned echo off by using the Echo action. When echo is off, Access suspends screen updates until the macro is finished.

Access automatically resets the Hourglass On argument to No when the macro finishes running.

Note Note

  • In Microsoft Windows, this is the icon you set for Busy in the Mouse Properties dialog box of Windows Control Panel. The default for all Windows operating systems is an animated hourglass icon.

  • You can choose another icon if you want.

To run the DisplayHourglassPointer action in a Visual Basic for Applications (VBA) module, use the Hourglass method of the DoCmd object.

Show: