question

EricLindberg-7224 avatar image
0 Votes"
EricLindberg-7224 asked EricLindberg-7224 commented

Access 2016 report truncated in Print Preview

Hi all,

Our agency is using Access 2016 on a server with no printers attached. When a report is displayed in Print Preview mode, the report is truncated on the right. If the same report is displayed in Access on a computer with printers defined, it is OK. When the report is exported to Word rich text format, it is also OK (no truncation).

Our users in a remote office need to use Access on this server for performance reasons, and the server admins don't want to attach any printers to the server for security reasons.

Is there any setting to change, either in Access or the report object, to correct this problem?

Thanks,
Eric Lindberg

office-access-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

There doesn't need to be a physical printer installed, just a driver. Depending on the server version, there is typically at least one installed. More recent versions include Microsoft Print to PDF. Even older version usually have Microsoft XPS Document Writer. Either should work fine if you are using standard paper sizes. Check the users' default printer. It may just need to be set.

0 Votes 0 ·
DanielPineault-1898 avatar image
0 Votes"
DanielPineault-1898 answered

Access bases report generation on your printer. The only thing you could do would be to change the margins to suit the server default Windows printer settings until they aren't truncated, but this will then impact your other users.

Or create a 2nd version of the report with the margins change to suit the server. This way current users aren't impacted.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BobLarson-6601 avatar image
0 Votes"
BobLarson-6601 answered EricLindberg-7224 commented

Could the server admins be persuaded to install a pdf printer to the server?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks, they seem to have a problem with that too.

0 Votes 0 ·