Solved

How to force report to open in Print Preview mode

Posted on 2008-10-28
3
305 Views
Last Modified: 2012-06-21
I have built a report that uses the OnFormat event of the Detail section to capture and calculate values for later use in the report. However, this event only fires when the report is being viewed in Print Preview mode. Is there an event that will fire whenever the detail level of the report is filled in, regardless of the view? If not, how do I force the user to always be in print preview mode? The Switchboard seems to want to always open in Report View mode.
0
Comment
Question by:Rich
[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
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 22823171
Use a command button to open the report:

Private Sub Command1_Click()
DoCmd.OpenReport "Report1",acViewPreview
End Sub

mx
0
 
LVL 75
ID: 22823199
If necessary, change the Switchboard command to Run Macro, then have the Macro open the report in Preview mode.

mx
0
 

Author Closing Comment

by:Rich
ID: 31510790
Thanks. That is what I need to do.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

710 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