PDF File sizes

[gemma-the-husky]

I used to generate PDFs in A2003 with Leban's code, and they came out at about 10K.

in A2010 these same PDFs are coming out at about 250K - whether i use docmd.outputto, or still use the previous code

is there any way to reduce the size of the pdfs?

 

[spikepl]

Change all fonts for all controls, labels, and any text what so ever etc to arial and be amazed

 

[gemma-the-husky]

I will try that to see what happens, but this isn't a generally valid solution, as many of these PDFs are invoices etc.

 

[spikepl]

his isn't a generally valid solution, as many of these PDFs are invoices etc.

I don't follow. Office uses Calibri as default (since Office 2007), so whether it is Calibri or Arial all over what is the difference? You could also use Time New Roman and Courier or a mix thereof.

 

[gemma-the-husky]

if someone uses a "house" font, then you can't just arbitrarily change it.

i just can't understand the sudden jump in size - so I will investigate a bit more.

 

[gemma-the-husky]

spike -

bit of playing around, and thinking of your advice in #2 - i tried changing the calibri fonts to arial and/or times new roman - and lo and behold - small pdf's. Times New roman seems to work better to be honest.

so not sure if its calibri on its own, or mixed with others - but calibri seems to be the problem - and if you google pdf/calibri issues you do find some problems.

anyway, i have added a font selector to enable the calibri fonts to be changed to a different font at run time, if it becomes a problem.

 

[spikepl]

I have an unsubstantiated theory about all this. Arial and Times New Roman are pretty standard widely used fonts, Calibiri isn't. So a PDF wih Calibri would have to include font data, whereas the two other fonts could be predefined in the PDF-reader/viewer.