You can use the DisplayHourglassPointer 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 DisplayHourglassPointer 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 DisplayHourglassPointer macro action in a Visual Basic for Applications (VBA) module, use the Hourglass method of the DoCmd object.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!