Changing from acFormatSNP to acFormatPDF

[GaryK]

Hi,

I have a Access app that basically loads csv datafiles and creates mailings (letters) based on the csv data and an Access report.

The VBA uses:
DoCMD.OutputTo acOutputReport, "rptLetter", acFormatSNP, "C:\letter.snp",,, acExportQualityPrint

However, some of our users have moved to Office 2010 and SNP is not supported - the SNP file is generated, but the SNP Reader throws an error.

So, I have changed the VBA to use acFormatPDF and this works fine with Access 2007 - the resulting PDF is formatted as expected.
But although 2010 creates the PDF, the character spacing is all bunched up and does not look good.

Is there anything that I can do?

Both machines are running Acrobat Reader 9.

I also tried using acFormatRTF, but this is not suitable as the report contains an image which is not output to the rtf file.

Thanks

 

[vbaInet]

Maybe it's the font you're using. Which font is it?

Can you upload a sample db with the report and some test data?

 

[GaryK]

Thanks for the reply....

The Report uses Arial font.
I have tried changing it to a couple of other fonts, but the PDF still has the same problem.

However, I have just discovered that the PDF may be a bit of a red herring....
If I go to the Print Preview of the report itself, the text is also bunched up.

So, we can ignore PDF and focus on why the report output is different to Access 2007 (uregardless of which font is used).
The report was designed using Access 2007 (or maybe an even eralier version of Access) - could this be the cause of the problem?

Any ideas/suggestions?


(I dont have a sample db available at the moment, but will see if I can get something prepped in the next couple of days.)

 

[vbaInet]

Try recreating the report in Access 2010 and see how it looks. You can copy and paste the controls across.