MS Access 2013 runtime report page size


I have an access database which has been running for years but in a full access environment.
It includes a report which uses every millimeter of an A4 page.
I have created a scaled down version of the front end which I have deployed to a remote computer which has the runtime version installed.
When this report is generated in the runtime environment is uses "Letter" size, whereas the design specifies A4 size.
Consequently the output (sent to pdf) is truncated
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Report rendering is highly dependent on the printer and/or driver being used.

 Unless you have exactly the same printer and driver setup, you may see minor differences in output.

 So the first question is, does the current printer/driver being used support the A4 page size?

peterjmcconnonAuthor Commented:
Thanks for the input Jim.
I am using the output command with pdf format.
The application is running on a virtaul web server and there are no actual printers connected. The default printer is Microsoft XPS Document Writer
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
So your using the Office PDF plugin?

On your full version, if you rename the DB .accdr and execute (or use the /runtime switch), do you get the same result?

IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

peterjmcconnonAuthor Commented:
I have not explicitly setup the Office PDF plugin, (nor any other pdf product) but I presume that as Access is part of the office suite then the default pdf facilities would be the office plugin.

Changed my db to accdr on my development machine and do NOT get the same symptom. The output is sized to A4.
Jeffrey CoachmanMIS LiasonCommented:
My take on this:

a report which uses every millimeter of an A4 page
So this seems to be the basic issue.

In my experience, reports that stretch the limits of the paper they are printed on, ....perhaps need to have thier designs rethought...

A4 is taller and narrower than Letter sized paper.
So my guess is that the Taller A4 margin is the issue.

Many printers manufactured in the US "claim" to support A4, but many only do so by presuming that the margins you set will be large enough to accomodate either format.
(My guess is that the same will be true for Printers manufactured for "A" sized paper.)
As an example
... on a standard letter page, ...the smallest printer margin I have ever been able to set is .17 inches (4.32mm)
(Again, guess is that the same will be true for Printers manufactured for "A" sized paper.) the maximum printable area of a letter sized paper will be about:
11.5-(.17 *2)
11.16 or 283.464 mm

Moving these calculations to A4 sized paper we get:
11.36 or 288.544 mm

So here we see that a report printed all the way out to 288.544mm (11.36 inches), will be truncated at 11.16 (283.464 mm) in on letter sized paper.

Reduce the vertical size of the report so that it fits inside the 11.16 inch  (283.464 mm), absolute margin limits of letter sized paper.
To keep this simple,
...Any report 200mm (7.9 inches) max width, ...and 267mm (10.5 inches) max height, ...will fit on either paper size.

There is no facility to "shrink to fit" using the Access built in PDF functionality
The issue here seems to be the size of the report, not the PDF output. (if I am reading this thread correctly)
The PDF is simply a graphical representation (as saved version) of the printers output codes, other words, ...printing a the report or printing the PDF will result in the exact same output.

Again if a Report:
uses every millimeter of an A4 page may wish to consider redesigning the report to not be so "confined"
(reduce what is displayed, reduce the font size, only display summary info (no details), insert a page break, ...etc)
...or simply move up to the next paper size...

peterjmcconnonAuthor Commented:
Thanks Jeff for your input.

The report is a scoresheet for volleyball, and the standard scoresheet in a non computing environment is an A3 size (double A4 size). It was quite an achievement to make it work on A4 and still be readable/usable.
Further reduction is not relevant.
It could possibly be reshaped to suit Letter, but then different format would be necessary depending where the final printout will occur. Nobody has Letter paper in this part of the world.
As for move up a size - that would mean every potential user has to buy differnt/bigger printers.

Surely the solution I should be seeking is to find that setting or tweak to have technology perform as stated. I am sure the solution to this is trivial, for the person who knows.
Jeffrey CoachmanMIS LiasonCommented:
Further reduction is not relevant.
It could possibly be reshaped to suit Letter,
These two statements are conflicting... you cant really "reshape" the A4 doc to fit letter paper without reducing the height.

Is it possible for you to post a screenshot of the full report in a4 size?

Perhaps Jim or I can provide some suggestions...
peterjmcconnonAuthor Commented:
Here is an example, but I still feel we should be looking to find how to be able to use A4 size paper, not be forced into using Letter
peterjmcconnonAuthor Commented:
Problem solved.

The Microsoft XPS Document Writer settings were being referenced it seems. I changed the settings on that printer in control panel, and the pdf output now matches my development machine.

Thanks to Jim and Jeffrey for taking some time to attempt to assist me.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
peterjmcconnonAuthor Commented:
Because it worked!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.