Hourglass won't display

[Guest]

I'm using docmd.hourglass (docmd.hourglass = false) in an attempt to change the mouse pointer. It doesn't appear immediately though. I have allot of code executing in other modules before I display a report. But the long pause before the mouse pointer changes to the hourglass makes the user think nothing is happening and they click the button again.

 

[Dirk Goldgar]

I'm using docmd.hourglass (docmd.hourglass = false) in an attempt to
change the mouse pointer. It doesn't appear immediately though. I
have allot of code executing in other modules before I display a
report. But the long pause before the mouse pointer changes to the
hourglass makes the user think nothing is happening and they click
the button again.

"docmd.hourglass = false" isn't valid syntax. If that's really what
you're writing, I don't see why an error isn't being raised -- unless
you're ignoring errors in your code. Maybe the error is just in this
posting and not in your code, but just in case, I'll advise you that the
command to turn the hourglass on is

DoCmd.Hourglass True

and to turn it off again

DoCmd.Hourglass False

If you actually have the correct code, and the cursor still isn't
changing immediately, you might try

Application.Echo True

or

Me.Repaint

(depending on the circumstances) to see if it makes a difference.