acViewPreview

Question

I am trying to display an Access report on my screen. When I use

acViewNormal in my code I get a paper copy of the report but if I

insert acViewPreview in the code nothing happens. Any suggestions?

Answer 1

Grinding through it one at a time, unless you want to try writing some VBA that opens each report in design view, and alters some properties via the Printer object. I'm not really sure this would work; I have only done this at runtime. Typically most reports should be set to "Default Printer".

Maybe it would be quicker to revert to a backup from before the snafu happened?

Answer 2

I've checked that, just to find that my printer is now set for a label printer. This is very strange because all 96 reports  show the label printer as the printer. I've checked my other access db and the printer for all that reports is also the label printer.  How can I change it for all my reports?

Answer 3

If you open the report in Design view, can you see your design? If so, then click the Page Setup and make sure that the report is using the right Printer.

Answer 4

I am using this reports everyday and it was working fine, but all of a sudden it shows a narrow, tall frame with nothing in it.  If I select to print it, it print the one page report over 365 pages. Even if I print to pdf format.

If I click on it in the Nav Pane, I receive exactly the same .... narrow, tall frame with nothing in it.

I've change the acViewPreview to acViewReport, then I can see my report on the screen but can't print or print to pdf.

Answer 5

acViewPreview should show you the report onscreen. Can you preview that report using other methods, like clicking on it in the Nav Pane?