MS Access foreign characters

We accept online orders which are then imported into Access. Some foreign characters are diplayed properly, but others are replaced by characters such as "|".

Also, when printing out a report that contains these replaced foreign characters, they are completely blank - that is they do not print out either the correct foreign character OR the replaced character...there is just blank space instead.

Anyone know of a fix for this, or know what could be causing this? I'm hoping it would be an automatic fix and not need manual updating/replacing.

Thanks -
mikalakaAsked:
Who is Participating?
 
TextReportConnect With a Mentor Commented:
Hi, Firstly ensure the form and report are using the same font. I assume that you are importing text files using standard ASCII characters set, you should try and match the caracter set that you are using with a font that supports that characterset, this may be just trial and error. Try creating a text file all the ASCII characters in in from 32 to 255 and import to test.

Cheers, Andrew
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - Answered by: TextReport  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
NetminderCommented:
Per recommendation, force-accepted.

Netminder
CS Moderator
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.