By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,965 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,965 IT Pros & Developers. It's quick & easy.

Special Characters Not The Same In Access as Excel, Word

P: n/a
I'm trying to enter some specific special characters (Ω, ±, ≥, ≤ for example)
in Access. Knowing that ASCII should be ASCII, but with variations (the
spice of life, right?), using the "Hold Alt and use the numeric keypad to
enter ASCII number" method, I went from 1 through 255 in Excel to find the
symbols I wanted. Then I went into Access and attempted a Find and Replce to
get rid of stuff like +-. <=, >=, etc. I was able to convert +- to ± without
problems. However, when I entered the codes for the other characters I
listed above, what came up were totally different characters. In fact, going
from 1 through 255 in Access did not bring up Ω, ≥, or ≤ at all.

Why the difference? What I got in Excel I checked and verified that the same
characters came up in Word. Is there some way to get the characters I'm
after?

Ken

--
Message posted via http://www.accessmonster.com

Mar 18 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Sun, 18 Mar 2007 17:22:28 GMT, "orgelizer via AccessMonster.com"
<u32431@uwewrote:

Same font?
Check Accessories System Tools Character Map.

-Tom.

>I'm trying to enter some specific special characters (?, , ?, ? for example)
in Access. Knowing that ASCII should be ASCII, but with variations (the
spice of life, right?), using the "Hold Alt and use the numeric keypad to
enter ASCII number" method, I went from 1 through 255 in Excel to find the
symbols I wanted. Then I went into Access and attempted a Find and Replce to
get rid of stuff like +-. <=, >=, etc. I was able to convert +- to without
problems. However, when I entered the codes for the other characters I
listed above, what came up were totally different characters. In fact, going
from 1 through 255 in Access did not bring up ?, ?, or ? at all.

Why the difference? What I got in Excel I checked and verified that the same
characters came up in Word. Is there some way to get the characters I'm
after?

Ken
Mar 18 '07 #2

P: n/a
I used the default fonts for each program, which I believe was Arial in each
case. I tried the Character map, entered the code to get the combination of
>= (≥) in the search box, and came up with no character found.
Ken

Tom van Stiphout wrote:
>Same font?
Check Accessories System Tools Character Map.

-Tom.
>>I'm trying to enter some specific special characters (?, ±, ?, ? for example)
in Access. Knowing that ASCII should be ASCII, but with variations (the
[quoted text clipped - 11 lines]
>>
Ken
--
Message posted via http://www.accessmonster.com

Mar 18 '07 #3

P: n/a
I just discovered more info. If I try to enter directly into a table, the
method I use gives me the characters I want. However, it's when I try to
denter the same thing in the "Replace" field (i.e., Find and Replace) that
things don't go the way I expect.

Ken

orgelizer wrote:
>I used the default fonts for each program, which I believe was Arial in each
case. I tried the Character map, entered the code to get the combination of
>>= (≥) in the search box, and came up with no character found.

Ken
>>Same font?
Check Accessories System Tools Character Map.
[quoted text clipped - 6 lines]
>>>
Ken
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200703/1

Mar 18 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.