How do i display a message while a procedure runs in the background? 2

[shellj]

I have a userform which has a command button FINISH which updates a form with all values entered by the user. I would like to display a message while the form is updating. How do I do this? Thanks.

 

[Junior1544]

have an unbound text box that has a default value of
"Working" or what ever you want... Make it big enough to get their attention and make it an odd color...

Set it's visable property to no...

In your code put this...

me!textboxname.visable = true
me.repaint

'all the code that does your work on the form.

me!textboxname.visable = false
me.repaint



Hope this helps...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[shellj]

Thanks for this James - it works great when I have one page in my form but how do I get it to work across multiple pages?

 

[Junior1544]

what do you mean you have multiple pages in a form??

I don't understand what it is you are looking for... If you'd like me to take a look email me the file.

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[rmikesmith]

Shellj,

If you mean you are using a MultiPage control on your form, you could size this control and/or the form to display a blank area of the form. In this area, place the TextBox as James indicated. This will be visible (when turned on by code) regardless of which page is currently active.

Hope this helps
M. Smith

 

[Junior1544]

You got it mike smith...

--James junior1544@jmjpc.net
Life is change. To deny change is to deny life.