Solved

Open report using VBA in normal view without printing?

Posted on 2011-02-18
5
755 Views
Last Modified: 2012-08-14
I am new to using reports in Access and I am trying to open the report using VBA without printing.

From searching the web the only way I can find to do this is by using:  docmd.OpenReport "Name", 'acViewPreview'. I don't want to display the report in print preview mode, just the standard report view as if I had clicked on the object manually.
0
Comment
Question by:wipnav
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 75
ID: 34928104
These are your options ... see image

mx
Capture1.gif
0
 
LVL 75
ID: 34928121
"as if I had clicked on the object manually."
That is the same a Print Preview.

Normal ... will directly print the report to printer ...

mx
0
 
LVL 1

Author Comment

by:wipnav
ID: 34928136
I'm on 2007 and when I double click the report object it opens in a full screen and my ribbon does not change to print/preview mode.

Print preview mode splits the report into multiple pages if the column widths are too great.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 34928151
Use acViewReport instead of acViewPreview
0
 
LVL 1

Author Closing Comment

by:wipnav
ID: 34928207
Thank you. I didn't see that option at the bottom of the list =P
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question