Accent marks & foreign characters

[GeoRReyes]

Hello,

I'm having an issue with foreign language characters (that have accent marks) not being accepted in our database input fields when a user tries to enter them into the textbox. i've enabled foreign languages, checked help menus, used the character map in accessories, and even tried using the alt+# method but to no avail.

since our company works with many foreign countries, many of the firms names have all sorts of crazy accents (à ã ç ö š ǐ ø) and as you can see from that example, one already showed up incorrectly as a box instead of an "i" with the "u" looking accent above it. I've attached a screenshot to this post so you can see what i'm talking about, however in the example it's the "s" with the "u" looking accent that doesn't show in access, as opposed to the "i" replaced by a box in this post.

My question is, is there any way of adjusting our system so as to make sure all accents are allowed? If you also have a list of steps that I can follow, I can try to redo it your way since the ones I've tried have not worked.

Any help would be greatly apprecaited. Thanks in advance!

 

[Jon K]

Maybe it is the display font.

On my system, the characters display incorrectly in System font, but correctly in Arial font as in the jpg attached.
.

 

[fasternu]

i have similar problem where special foreign characters are not being imported into the table correctly. where can i change how the data is imported so the accents are not lost? I can import into excel without any issues.

 

[NinoScholz]

i have similar problem where special foreign characters are not being imported into the table correctly. where can i change how the data is imported so the accents are not lost? I can import into excel without any issues.

We are also havign this problem with importing data into access and foreign characters changing. Is there a setting somewhere that can be changed? Any help is appreciated.