PDF optimization?

[hkimpact]

Good morning everyone -

I have written a procedure in VBA that grabs information that a user selects in a combobox and then generates a PDF file. You can either view this file or at the click of a button it will automatically send to the correct users folder located on a local shared drive.

Each of these PDF files can be anywhere from 275KB to 300KB in size. Is there a way to optimize a PDF within Access before I send these files to users folders?

Thank you in advance
Rick

 

[spikepl]

You can save huge amounts of space by selecting a common font like Arial or Times New Roman as font for absolutely everything in the report to be PDF'ed, i.e. ALL control texts and labels , instead of the default Calibri, because in the latter case the PDF-thing also stores the font. If just one character in your report is formatted with Calibri, then the PDF-thing will store the entire font.

BTW: The sun never sets on AWF, so a "good morning" does not make much sense

 

[hkimpact]

@spikepl,

Thank you for letting me know that. Its amazing how much of a difference that made in the file size. I chose Arial and it shrunk from 183kb to 24kb. Thank you for letting me know this

 

[spikepl]

Good to hear. On reflection, I am not 100% sure that my explanation is the correct one, but who cares, so long as it works.