Discussion Locked

Can't get accents to work in MS ACCESS

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to use accents in text fields in an Access database. Examples: forward and backward accent over an "e" or a ^ over an "i". I can get them to work in Word but not in Access. In Word, I use CTRL forward apostrophe, e. Access copies anotherfield instead of inserting the accent. Are there different commands for Access? Multi language support is installed on my PC. What am I missing? This is driving me crazy..... I've checked Microsoft's website with no luck... Thanks.

9 replies

by sl-campbell

Press and hold the left ALT key and type on the number pad the character code (like ALT 228).

by sl-campbell

I have no problem - What do you mean by "Normal"?
Try some other combinations like Alt-144 (again, type the numbers in from the number block).
You can get a list from the MS site. Do a search on "Character Codes" or "ANSI Chart"

by happytrails

No, it doesn't work. I tried ALT 228 and the type comes up normal. I might be typing in the incorrect character codes; where can I find a list of codes?

by lgs21

One easy fix is to type the text in MS Word,then cut and paste it to the Access field where you want it - sounds clumsy but actually usually quicker than looking up the ASCII stuff reference (using the ALT key method). You can have both Access and Word open and simply toggle between them. Hope that helps.

This discussion is closed to new replies.