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
ridders
Newbee moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,566
Thanks: 79
Thanked 1,379 Times in 1,286 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
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, 96 views)
File Type: png PrintPreview2Down.PNG (82.0 KB, 94 views)

__________________
Colin
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.


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

New example databases:
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.


-------------------------
nil illegitimi carborundum est
ridders 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
ridders
Newbee moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,566
Thanks: 79
Thanked 1,379 Times in 1,286 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
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

__________________
Colin
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.


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

New example databases:
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.


-------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
mcescher (04-13-2018)
Old 04-16-2018, 11:25 AM   #4
ridders
Newbee moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,566
Thanks: 79
Thanked 1,379 Times in 1,286 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Print Preview 1 across 2 or more down

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

__________________
Colin
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.


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

New example databases:
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.


-------------------------
nil illegitimi carborundum est
ridders 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 12:36 PM.


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