TextBox carriage return displays question mark in box when saved as PDF

Hi,

I have TextBoxes that are multiline enabled. When a textbox that includes carriage returns is loaded to a worksheet cell it looks fine. But, when saved as a PDF it has a question mark in a box for each carriage return.

Is there a way for these boxes to not be visible in a PDF?

I notice that if I add a carraige return in a cell directly (using Alt + Enter) and save as a PDF, there are no boxes on the PDF. It is only when I add a carriage return in a TextBox (using Ctrl + Enter) that it happens. Is it a formatting issue?

Thanks in advance.

NOTE: I'd include a screen shot, but I get a 407 error when I try to use Insert Image.

Hi nickwoowoo

Chr(10) = linefeed
Chr(13) = Carriage return

The following all give a new line - do any of them work for you?

Please Login or Register  to view this content.

Regards
Alastair

Hi aydeegee,

Thanks for your reply,

They all gave the same result. To clarify, the carriage returns/new lines are on the PDF, but there is a question mark in a box at the end of each line.

Regards,

nickwoowoo.

Hi nickwoowoo

Yes, I understood the situation, I just hoped that one of the different codes might give no question mark in a box. Sorry it did not work

Regards
Alastair