Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Full Page View

Status
Not open for further replies.
Dilly

Dilly

Technical User
May 28, 2001
41
0
0
GB
Can anyone tell me if its possible to force a report to open to full page view insted of only being able to view part of the report.
 
Sort by date Sort by votes
In your code, put something like this:
Code: 
DoCmd.OpenReport "rptYourReport", acViewPreview
DoCmd.Maximize
DoCmd.RunCommand
acCmdFitToWindow

Other possibilities would be to open a report at a predetermined zoom rate, substituting one of these RunCommand statements for the one above:
Code: 
 DoCmd.RunCommand acCmdZoom10
 DoCmd.RunCommand acCmdZoom25
 DoCmd.RunCommand acCmdZoom50
 DoCmd.RunCommand acCmdZoom75
 DoCmd.RunCommand acCmdZoom100
 DoCmd.RunCommand acCmdZoom150
 DoCmd.RunCommand acCmdZoom200
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
192
dhookom
dhookom
Zandy12
  • Locked
  • Question
Repeat the Report Header after Page Header / Details ends.
Replies
1
Views
310
dhookom
dhookom
RonMcIntire
  • Locked
  • Question
Page Numbering a report with vba
Replies
6
Views
148
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
209
dhookom
dhookom
lmcate
  • Locked
  • Question
Limit the PDF Report to each Agency per Page 1
Replies
3
Views
85
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top