OutputTo Pdf with distorted letters

[jsdba]

Hi,

I have a report that i export to pdf from access 2010 using OutputTo. The report is about 10 pages long. Every time i run this report, at page 5 and beyond, random letters become distorted, sometimes with a box sometimes with a question mark. All fonts I've tested are embedded. Times New Roman, Calibri, Arial, Georgia and others. After googling for hours i still don't have a solution. Attached is a sample of of the distorted pdf output. Any help is tremendously appreciated.

 

[vbaInet]

This is happening on a Memo field right?

 

[jsdba]

YES!!! I though that could be problematic. Should i change to text field?

 

[vbaInet]

It depends the maximum number of characters each record holds. Text is 255, so is the memo field length within that mark?

 

[jsdba]

Yes and No, most will fit within the 255 limit but some will not.

According to Microsoft "Use the Memo data type if you need to store more than 255 characters. A Memo field can store up to 65,536 characters. If you want to store formatted text or long documents, you should create an OLE Object field instead of a Memo field."

I've never worked with OLE object before other than for creating a field for a picture.

 

[vbaInet]

With Rich Text you can store formatted text in a Memo field.

Here's a link that should help address your issue:

http://allenbrowne.com/ser-63.html

 

[jsdba]

Rich Text did the trick. thanks vbaInet

 

[vbaInet]

You're welcome!