Export (0) Print
Expand All
Expand Minimize

DoCmd.Hourglass Method (Access)

The Hourglass method carries out the Hourglass action in Visual Basic.

expression .Hourglass(HourglassOn)

expression A variable that represents a DoCmd object.

Parameters

Name

Required/Optional

Data Type

Description

HourglassOn

Required

Variant

Use True (–1) to display the hourglass icon (or another icon you've chosen). Use False (0) to display the normal mouse pointer.

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

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

Microsoft Access automatically resets the HourglassOn argument to False when the procedure finishes running.

Community Additions

ADD
Show:
© 2014 Microsoft