<div>
I'm not sure about using VBA however there is another way to do it. Install PDFCreator from SourceForge. It is open source and free. Set PDFCreator as default printer. Print a document and select Options. Go to Auto-save and tick Auto-save and &quot;After auto-saving open the document...&quot;.
</div>


I'm not sure about using VBA however there is another way to do it. Install PDFCreator from SourceForge. It is open source and free. Set PDFCreator as default printer. Print a document and select Options. Go to Auto-save and tick Auto-save and "After auto-saving open the document...".

<div>
This worked perfectly. &nbsp;The only thing is it seems to open the pdf at 105%. &nbsp;I wish it was about 75%.
</div>


This worked perfectly.  The only thing is it seems to open the pdf at 105%.  I wish it was about 75%.

<div>
<div class="content wysiwyg-content">
I'm having a problem with image resolutions (another topic) and want to try a work-around.<br />
<br />
Is the a way via VBA to from a command button on a form, print a report to a pdf and then have that pdf report appear on the screen right away?<br />
<br />
--Steve
</div>
</div>


I'm having a problem with image resolutions (another topic) and want to try a work-around.

Is the a way via VBA to from a command button on a form, print a report to a pdf and then have that pdf report appear on the screen right away?

--Steve

How print report to pdf and have it open right away on screen

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.