Display hourglass

[Guest]

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.

 

[Perry]

Docmd.hourglass -1

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

 

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

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

 

[Guest]

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.

 

[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