Problem displaying all text when copied from a PDF

[jjake]

I have a form that i copy text into from a PDF which then generates a report. I'm having an issue when the PDF displays the text on different lines.

When i copy this into the text box, it displays it as it was when i copied it (I have to scroll down the text box per line)

The issue is that when i generate a report it only displays so many paragraphs and stops.

The report is set to can grow and can shrink and the text box is also set to long text.

Other then that it works just fine. Only paragraphs (multiple Lines)cause an issue.

 

[liddlem]

The problem lies with the manner in which the PDF was created. - You might want to paste the text into notepad / word to "clean it", before putting it into access.

In word, use the search and replace tool to remove paragraph (or carriage returns) etc

 

[jjake]

I tried this but I still had the same problem.

I also counted my characters that are displayed on the report and I have 251 showing but I have 1125 I need to display. I changed the field in my table to Long Text and remade the textbox with the new field on my report but it's still showing 251 characters.