Display hourglass

G

Greg Snidow

Greetings all. Is there a way to show an hourglass while a form is loading?
I am using Access 2003. I have seen references to this topic, but I can not
find an answer. Thank you.
 
P

Perry

Docmd.hourglass -1

Don't forget to toggle it back at the appropriate moment...
Krgrds,
Perry
 
F

fredg

Greetings all. Is there a way to show an hourglass while a form is loading?
I am using Access 2003. I have seen references to this topic, but I can not
find an answer. Thank you.
Click to expand...

DoCmd.Hourglass True
' some more code here
DoCmd.Hourglass False
 
G

Greg Snidow

Thanks Perry. The hourglass works to a certain extent. On my form I have
used labels with click events to navigate rather than buttons because I like
them better. The last line of my form_open event is docmd.maximize and that
is where I put docmd.hourglass false. Even after the form is maximized the
labels still are not active for a few seconds at which point they will become
a little bit brighter. How can I know what is going on after the form has
maximized but before the labels are useable? I would like for the hourglass
to remain until the labels become active. Thank you.
 
P

Perry

Force a repaint before you maximise and include a DoEvents statement
after the maximise command.
Leave the Hourglass timing as you've set it.

Krgrds,
Perry
 
Top