Report preview doesn't work first time Access is opened..

[franksirvent]

Hi

I have an MDE database which the very first time it runs a report (which always previews first), it doesn't display/preview.

In order to see it, I have to click on the Access icon on the Windows bar, then its there (the code makes the Form unvisible before previewing report).

What's funny is that the 2nd, 3rd, etc times, it previews correctly, no need to click on the Access Icon on the windows bar !!!

it only happens the 1st time you run the report.

I don't have any code which makes it do that, so I would like to put some code on the Report which 'forces' to be maximized/visible everytime its run.

I do have docmd.maximize on the report_open

Anything else I am missing ???

 

[Crowley16]

the code you use to hide the form is actually minimizing the access window in which reports appear...

instead of trying to hide the form, minise the form instead, or just set focus to the report and it will automatically bring that forwards on top the form, unless you've got the form as popup...

--------------------
Procrastinate Now!

 

[franksirvent]

thanks for that...it doesn't seem to work

I have put

sub report_open()
reports![Print Standard].setfocus
docmd.maximize
....

On the form I have

But it doesn't work, still does the same thing...

Any more ideas ???

 

[Crowley16]

you have to disable the code which hides the access window...

or have some code to unhide the access window before trying to open a report...

--------------------
Procrastinate Now!