Lost characters when exporting reports to pdf

[QTT]

Has anyone ever experienced characters being converted to weird symbols when exporting to pdf?



Using Access 2010, I use a make-table query to generate a table. One of the fields "Notes" occasionally has hard-returns within the records. I run an update query to replace the hard return with a space:
UPDATE Tablename SET FIELD_NAME = replace([FIELD_NAME], chr(10), chr(32));

and another to shorten "Notes" to 255 characters and add an ellipsis at the end:
UPDATE Tablename SET FIELD_NAME = left([FIELD_NAME],255)&"...";

I use a set of queries to generate several reports based on this table, and a macro to export them all to pdf. When I open the files in acrobat, the "space" I created in the first update query is converted to this bizarre ?-in-a-box character. I have tried replacing the chr(32) with "..." and got the same result. I can't publish the report with these unknown characters, but don't know where they come from or how to get rid of them.

Thanks in advance for any support.

[June7]

Maybe because hard returns are actually two non-printing characters - Chr(13) & Chr(10) - Cr & Lf.

Try: Replace([FIELD_NAME], Chr(13) & Chr(10), " ");

[QTT]

Maybe because hard returns are actually two non-printing characters - Chr(13) & Chr(10) - Cr & Lf.

Try: Replace([FIELD_NAME], Chr(13) & Chr(10), " ");

I couldn't make this work, and couldn't figure out why. I had switched the 10 and the 13, assuming it didn't matter the order. Apparently it does. Thanks for your assistance.

[June7]

Yes, order does count, sorry I did not think to comment on that. Cr usually precedes Lf. Enter key will save codes in that order.