MS Access foreign characters

Posted on 2002-07-07
Last Modified: 2013-12-03
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 -
Question by:mikalaka
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 28

Accepted Solution

TextReport earned 50 total points
ID: 7135599
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
LVL 54

Expert Comment

ID: 7260141

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.



Expert Comment

ID: 7296316
Per recommendation, force-accepted.

CS Moderator

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question