Hourglass Macro Action

You can use the Hourglass macro action in Access desktop databases to change the mouse pointer to an image of an hourglass (or another icon you've chosen) while a macro is running. This macro 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.

Important: Beginning in Access 2010, the Hourglass macro action was renamed to DisplayHourglassPointer.

Note: The DisplayHourglassPointer macro action isn't available in Access web apps.


The Hourglass macro action has the following argument.

Action argument


Hourglass On

Select Yes (display the icon) or No (display the normal mouse pointer) in the Hourglass On box. 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.


  • In Microsoft Windows, this is the icon you set for Busy in the Mouse Properties dialog box of Windows Control Panel.

  • You can choose another icon if you want.

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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!