Access to PDF Mixed Characters acFormatPDF

[ekryez]

Problem is that the output Pdf Report files have special characters displayed. When i Print to Pdf all is Fine. See attached.

MyProjectNumber = !ProjectNumber
MyProjectName = !ProjectName


MyFileName = MyProjectNumber & " " & MyProjectName & ".PDF"
DoCmd.OpenReport "Pipeline Total Report", acViewPreview, , "ProjectNumber='" & !ProjectNumber & "'"
DoCmd.OutputTo acOutputReport, "Pipeline Total Report", acFormatPDF, MyPath & MyFileName
DoCmd.Close acReport, "Pipeline Total Report"

[June7]

Apparently there are some non-visible characters that the VBA OutputTo method cannot interpret, although your PDF printer driver can.

[ekryez]

Apparently there are some non-visible characters that the VBA OutputTo method cannot interpret, although your PDF printer driver can.

Hi June is there any workaround?

[June7]

I don't know what is causing that character nor why it overprints other characters. Where does this text come from? Is it typed input or imported?

[ekryez]

I don't know what is causing that character nor why it overprints other characters. Where does this text come from? Is it typed input or imported?

Is imported from Excel.

[June7]

Then there is something in the text in the Excel file. If you want to provide for analysis, follow instructions at bottom of my post.

[ekryez]

Then there is something in the text in the Excel file. If you want to provide for analysis, follow instructions at bottom of my post.

Its bigger then 2MB so Drop Box

https://www.dropbox.com/s/o3mnv26l35...eline.zip?dl=0

[June7]

Can't download the file, my home internet is too slow for that size file and blocked at work. Was that just the Excel file?

[ekryez]

Can't download the file, my home internet is too slow for that size file and blocked at work. Was that just the Excel file?

i inserted the access db as well, below only excel.Internal.zip

[June7]

I imported the spreadsheet but the Summary and Challenges data truncated. However, I do get the issue with exporting report to PDF.

I deleted all the forced line returns in the Excel file and the odd symbols no longer show in the PDF.

Then I typed forced line returns in the Access data. Those do not export as odd characters.

Apparently forced line feed in Excel is incomplete and the PDF export doesn't translate it properly.

Run an UPDATE sql to replace the bad Lf character with CrLf.

UPDATE Master SET ProjectChallenges = Replace([ProjectChallenges], Chr(10), Chr(13) & Chr(10))


BTW, misspelled word in the summary for Saferay: for should be four

[ekryez]

Hi June, thanks again for the solution.