Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

Setting

The DisplayHourglassPointer macro action has the following argument.

Action argument

Description

Hourglass On

Select Yes (display the icon) or No (display the normal mouse pointer) in the Hourglass On box. The default is Yes.

Remarks

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.

Notes: 

  • 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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×