Print Preview 1 across 2 or more down (1 Viewer)

isladogs

MVP / VIP
Local time
Today, 02:34
Joined
Jan 14, 2017
Messages
18,186
This is a follow up from a recent thread by mcescher
https://www.access-programmers.co.uk/forums/showthread.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?
 

Attachments

  • 2x1PreviewMenu.PNG
    2x1PreviewMenu.PNG
    8.9 KB · Views: 165
  • PrintPreview2Down.PNG
    PrintPreview2Down.PNG
    82 KB · Views: 164

isladogs

MVP / VIP
Local time
Today, 02:34
Joined
Jan 14, 2017
Messages
18,186
Bounce....
Does anyone have any bright ideas?
 

Users who are viewing this thread

Top Bottom