Open a report, don't print it!

  • Thread starter Thread starter Roger Withnell
  • Start date Start date
R

Roger Withnell

I'm using DoCmd.OpenReport "Analysis report" to display a report on the
screen, but it prints it instead!

How do I make it display?

Thanks in anticipation.
 
The complete syntax for the OpenReport method is:

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

To only view the report, set the second parameter to acViewPreview:

DoCmd.OpenReport "Analysis report", acViewPreview

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Roger Withnell said:
I'm using DoCmd.OpenReport "Analysis report" to display a report on the
screen, but it prints it instead!

How do I make it display?

Thanks in anticipation.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change a report to a query 1
Printing one report 4
Select printer 1
Access report preview and print only the first page 2
printing 1 sheet of report 1
Changing a report with information from a form 2
Lost Focus ! 4
Printing copies of report without opening it 5

Back
Top