Export Form to PDF Resolution Issue

[brian7268]

After a user completes a form, they click a button at the end that uploads the information the back-end database and creates a PDF copy using the DoCmd.OutputTo function. It has been working fine, but one user just had an issue where the form was very zoomed in and cut off. So I have 2 questions:

1) Does anyone know the cause of this problem? Is it based on screen resolution?

2) Is there a way to fix the problem to make sure it does not happen?

 

[CazB]

I had a similar issue with a database I was working on - I didn't manage to get to the bottom of it, so my workaround was to output a report (which looked the same as the form) instead..... could that be an option for you?

 

[brian7268]

Thanks for the suggestion. I could look into that, but I would rather not. The form is very dynamic (different fields appear/disappear based on previous fields) and I'd rather not have to add the step in of generating a report.

 

[David R]

Have you investigated the screen resolution of the 'offending' user? 800x600 and low technical ability tend to go hand in hand...

 

[brian7268]

That is a very good point. Assuming, the "offender" is using a low screen resolution, is there any setting or code that can make the form export the same regardless of the user's resolution?

 

[brian7268]

UPDATE: I just changed the resolution of my laptop to 800 x 600 and completed the form. The PDF looked fine, so I don't think the problem is the user's resolution.

Any other ideas what might have caused it?

 

[David R]

The export should be the same resolution regardless of what the screen shows. Maybe it's something in the default zoom of their PDF viewer?

Try having them email you the output PDF if possible, and see if it shows up weird on your machine. I'm still guessing it's PEBKAC error.

 

[brian7268]

The database automatically emails the PDF after it is generated, so I have already received a copy of it. Unfortunately, it is the PDF itself that is messed up, not the viewer. The font size is off and the right and bottom of the form are cut off.

 

[David R]

That's really weird. Google thinks it's an Adobe PDF Printer problem: http://social.msdn.microsoft.com/Fo...tputto-method-in-legal-size-page?forum=isvvba has an idea for maybe how to solve it, assuming you can predict the printers that will be on that network.