?
Solved

In Access 2007, how can I get my reports to Preview as a full screen image?

Posted on 2010-11-30
10
Medium Priority
?
620 Views
Last Modified: 2012-06-27
In my adopted Access 2007 database, the reports will preview off of the viewable screen in a tiny box that you cannot enlarge unless you use the maximize button for the forms that generate the report.  If you are using the multi-window button, you will not easily find the report and you will not be able to preview the actual report, just a corner of it.  How can I make the report previews ALWAYS show in the Maximized size while allowing the forms to be multi-windowed?  
This is a database that has been in use and under reconstruction since Access 2.0 (1993-4)
0
Comment
Question by:PorterConsultingLLC
[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
  • 5
  • 3
  • 2
10 Comments
 

Author Comment

by:PorterConsultingLLC
ID: 34239925
I have been working with Access since 2.0, in 1993-4, and have never seen this behaviour.  I am hoping one of you knows how to put a line o code into the VBA to tell the report to always preview as a full screen.  Any ideas?
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 34239948
In your code that opens the report, after the DoCmd.Open report do:

DoCmd.Maximize

or alternatively:

DoCmd.RunCommand acCmdZoomxx  

  where XX is the factor, or the box (just start to type it and you'll get intellisense support onthe available options)
.

  Then in your forms OnActivate event, do:

 DoCmd.Restore

JimD.
0
 

Author Comment

by:PorterConsultingLLC
ID: 34240083
thank you SOOOO much!  I've been going nuts with this and your solution is easy and it WORKS.  Again, Thank you!

Laura
0
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

 
LVL 58
ID: 34240099
Laura,

  Quite welcome.  Glad to be of help.

JimD.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34241996
Also note that Explicitly Opening the Report in Print Preview will do this by default.
So instead of forcing this with code, set it once (Set the Default View property of the report to "Print Preview")

(The issue here is that the default View in Access 2007 is Report View, not Print Preview.)

;-)

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34242028
also note that if the report is opened in Print preview, the report will dynamically resize to always fit 100% in the window size.
0
 

Author Closing Comment

by:PorterConsultingLLC
ID: 34242202
Fast and easy solution to a nagging problem.  Because this database was originally created in Access 2.0 and reworked and upgraded for the past 15+ years it is full of code that we would not have to work with today.  This solution simply cut across all of the hassle and gave a simple solution.
0
 

Author Comment

by:PorterConsultingLLC
ID: 34242249
Yes, Jeff, the issue IS that this is setup to open in Report View, however, to change it at this point would be a major hassle.  All sorts of buttons and code that are interdependent and written in layers of modules and queries would have to be modified.  We have several of these and they are a pain, but if the code is not cleaned up after each upgrade in Access we end up having to deal with this kind of nightmare.  Thanks for your responses.  I really do appreciate them!
Laura
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34242351
OK,

Just remember that a lot or Report code you may have (on format events, ...etc) will NOT run in Report View...
You will also not see Page numbers/ page breaks, and graphics may not display properly.

In other words, Print preview is designed to display the Report exactly as it will be printed.
Report view is designed to let you view the report quickly and provide for "Interaction"

0
 

Author Comment

by:PorterConsultingLLC
ID: 34247975
Thank you for that heads-up.  This sort of decision was made long before I came to where I am currently working, though.  I will let folks here know of the pitfalls you are describing.

Again, thank you!

Laura
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…

762 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