How can I remove a Carriage Return Character from a report before exporting to a .pdf?

I have a report that generates in my Access database, and it displays perfectly from within.  The report has several unbound text boxes that are filled with multiple lines of options each time the report is created.  This is done because the options are different every time.  

I am generating a carriage return between each option because I want the list in the text box to look like this:

Option1
Option2
Option3

Instead of this:

Option1Option2Option3

I am forcing the carriage returns in the OnFormat event when the report is created by adding the following code inbetween each option:

& Chr(10) & Chr(13)

This all works fine within Access.  However, when I choose to export the report as a .pdf, the text boxes show a question mark inside of a square at the beginning and end of each line within the text boxes.

Example of unwanted characters
Is there any way to be able to export this report to a .pdf without these characters showing in the exported file?
jmccloskAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Not sure but using vbCRLF
...worked for me:

Me.txtStack = Me.FN & vbCrLf & Me.LN
reportpdf
sample db is also attached

JeffCoachman
Database53.mdb
0
 
jmccloskAuthor Commented:
Ahh, the simplicity of it!  Thank you!  That did the trick!
0
 
Jeffrey CoachmanMIS LiasonCommented:
This worked with unbound textboxes as well (in the report and the resulting PDF)
Modified sample attached as well:
Database53.mdb
0
 
Jeffrey CoachmanMIS LiasonCommented:
yes, ...in some situations the Character codes are beneficial,
In other cases vbcrlf maybe better,

This is why it is best to know both methods...
;-)

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.