Excel save as pdf

adh123

Registered User.
Local time
Today, 11:20
Joined
Jan 14, 2015
Messages
77
Not 100% sure if this is the correct area to post my question, if not please can this be moved accordingly?

With the help of people on here I have put together an access system for daily tasks for the staff at work. This particular issue involves users entering data into a memo field (enter key programmed to 'new line' in the field properties).
Daily info, such as customer orders, quotes etc is exported into excel and each is saved as pdf. Where a new line is entered on the form a ? appears inside a box at the end of the line.

Is there any way to remove these or a ch(x) that I should be using in access prior to exporting to excel which will do this for me?

Thanks very much in advance!

Edit: Changing the font from Calibri to Times New Roman seems to get rid of these?!
 
Last edited:
yes, font change can fix it.
other fonts don't know the character so it gives "?"
 

Users who are viewing this thread

Back
Top Bottom