Hourglass Macro Action

You can use the Hourglass 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.

Setting

The Hourglass 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.

Remarks

You often use this action if you have turned echo off by using the Echo action. When echo is off, Microsoft Office Access 2007 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. The default for all Windows operating systems is an animated hourglass icon.
  • You can choose another icon if you want.

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