Display status meter while report compiles...

[Datathumper]

I have a report that crunches several queries before opening, and I would like to launch a form while it is openning that would display the status bar that is found at the bottom left of the screen. I would then like to close it when the report is finally produced.

Is this possible??

Thanks in advance.

 

[DougP]

That will take a lot of code. But I have done this.
On your form where you print from. Have a Label with its Visible property set to false. The labels caption will be "Please Wait will Report loads...". I make it large so they see it and make the letters red on a yellow background if needed. Then in the report buttons click event turn the labels property Visible = true. like so

Me!Label1.visible = True
doevents   ' <<<< this is very important

' open report here

doevents   ' <<<< this is very important
Me!Label1.visible = False

DougP, MCP, A+