Hourglass (1 Viewer)

[MikeAngelastro]

Hi,

I have noticed that the DoCmd.Hourglass method works under certain circumstances but doesn't work under others. A situation in which it did not work is when I was resorting a tabular form after clicking on the label above a field. Because it was taking longer than I wanted to resort the form, I decided to use the hour glass to tell the user that the form was buzy. But Access totally ignored the command. Reading through some of the postings here I found out the I had to put the DoCmd.Hourglass method call in the mouse-down event of the label instead of the click event. This suggests to me that there are restrictions on when the DoCmd.Hourglass method will work. Does anyone know of a good summary of the Hourglass that will tell me when it will work and when it won't?

Thanks,

Mike

 

[Oldsoftboss]

Try, in the onclick event

'At the start of the code
Screen.MousePointer = 11 'Changes it to an hourglass


'At the end of the code
Screen.MousePointer = 0 'Resets it to windows default

HTH
Dave

 

[Oldsoftboss]

If you look up mousepointer in vbHelp all the options are listed.
Dave