Solved

How to force report to open in Print Preview mode

Posted on 2008-10-28
3
268 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
Comment Utility
Use a command button to open the report:

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

mx
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
Comment Utility
Thanks. That is what I need to do.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

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…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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…

744 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now