Msgbox, Access 2003

[Chai]

How do I display a message using Msgbox() for a specified length of time,
say, 5 seconds, without having the "Okay" button to click and having the
message box disappear by itself? Thanks.

Chai

 

[Dennis]

I don't think you can, but you can create your own form and set the timer
interval property to something like 5000 and then in the on timer event put
the code
DoCmd.Close
Instead of using MsgBox you can use DoCmd.Openform "YourMessageBoxForm"
and it will close when the 5000 milliseconds have elapsed.

 

[Keith Wilby]

How do I display a message using Msgbox() for a specified length of time,
say, 5 seconds, without having the "Okay" button to click and having the
message box disappear by itself? Thanks.

Chai

AFAIK you can't, but you can fake it by using a form as a dialog box and use
the timer event to close it.

Regards,
Keith.
www.keithwilby.com