Hourglass won't display

G

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.
 
D

Dirk Goldgar

DARAB said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top