?
Solved

MS Access foreign characters

Posted on 2002-07-07
3
Medium Priority
?
306 Views
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 -
0
Comment
Question by:mikalaka
[X]
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
3 Comments
 
LVL 28

Accepted Solution

by:
TextReport earned 200 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
0
 
LVL 54

Expert Comment

by:nico5038
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.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
LVL 5

Expert Comment

by:Netminder
ID: 7296316
Per recommendation, force-accepted.

Netminder
CS Moderator
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
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…

719 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