Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-10-2018, 12:19 PM   #1
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,541
Thanks: 88
Thanked 1,609 Times in 1,499 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Print Preview 1 across 2 or more down

This is a follow up from a recent thread by mcescher
https://www.access-programmers.co.uk...d.php?t=298862

In that thread the OP asked for VBA to open a report in print preview but with the pages scrolling downwards (as is the case for PDF files).

I know how to show multiple pages or change zoom using code
For example this shows 2 pages side by side
Code:
DoCmd.RunCommand acCmdPreviewTwoPages
Or replace Two with Four / Eight / Twelve / One as required

This shows the report at 50% zoom
Code:
DoCmd.RunCommand acCmdZoom50
Here you can also use 10/100/1000/150/200/25/500 instead of 50

However, I thought his request wasn't possible in preview mode.
To my surprise you can partly do that from the ribbon



Result:


I usually work on the principle that if you can do it from the ribbon, you must be able to do so in VBA.
However, I've been unsuccessful in finding a command line for this
Ideally, it should be one page wide and continuous scrolling down
Any ideas?
Attached Images
File Type: png 2x1PreviewMenu.PNG (8.9 KB, 109 views)
File Type: png PrintPreview2Down.PNG (82.0 KB, 107 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Web links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders

Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 04-12-2018, 01:32 AM   #2
Orthodox Dave
Home Developer
 
Orthodox Dave's Avatar
 
Join Date: Apr 2017
Location: London UK
Posts: 218
Thanks: 25
Thanked 49 Times in 49 Posts
Orthodox Dave is on a distinguished road
Re: Print Preview 1 across 2 or more down

Never tried it Colin, but there is acCmdPreviewOnePage
https://msdn.microsoft.com/en-us/vba...eration-access
__________________
Dave

The simplest solutions
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
can be the hardest to find
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Orthodox Dave is offline   Reply With Quote
The Following User Says Thank You to Orthodox Dave For This Useful Post:
mcescher (04-13-2018)
Old 04-12-2018, 03:53 AM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,541
Thanks: 88
Thanked 1,609 Times in 1,499 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Print Preview 1 across 2 or more down

Quote:
Originally Posted by Orthodox Dave View Post
Never tried it Colin, but there is acCmdPreviewOnePage
https://msdn.microsoft.com/en-us/vba...eration-access
Thanks for the reply Dave but I mentioned that in my original post along with variations such as acCmdPreviewFourPages
The link is useful though

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Web links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders

Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
mcescher (04-13-2018)
Old 04-16-2018, 11:25 AM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,541
Thanks: 88
Thanked 1,609 Times in 1,499 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Print Preview 1 across 2 or more down

Bounce....
Does anyone have any bright ideas?

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Web links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders

Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Tags
print preview scroll down

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
#error : Print preview/report preview JOKER20 Reports 5 07-18-2016 06:37 AM
Unbound Report - Print Preview OK but Direct to Print Fails sgrace Reports 3 05-26-2013 02:47 PM
Report is blank when opened. Print preview ok. Print ok fabiobarreto10 Reports 4 05-03-2012 07:54 AM
Report header looks good in print preview but doesn't print bumblingidiot Reports 8 02-16-2012 01:15 PM
Access button to print report instead of opening it in print preview vvangogh Modules & VBA 2 07-01-2011 10:45 AM




All times are GMT -8. The time now is 03:10 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World