Solved

How to force report to open in Print Preview mode

Posted on 2008-10-28
3
290 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
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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