Appendix ASCII Character Codes
Appendix ASCII Character Codes
T
his appendix is a listing of the 255 ASCII (American Standard Code for Information
Interchange) character codes that Access uses. They work in conjunction with the
functionsAscandChr.Ascwill give the ASCII number of a character, andChrwill
give the character based on an ASCII number.
All these characters can be used to produce text strings by using theChrfunction (see
Chapter 5). The following example will produce the string “ABC”:
MsgBox Chr( 65 ) & Chr( 66 ) & Chr( 67 )
You can also insert carriage return and line feed characters to make your text wrap at the
correct point.
In the table, the _ symbol indicates no displayable character exists.
Beyond character 128, Access uses an extended character set (which is not real ASCII)
that partially depends on the locale of the user and the PC being used. For example,
=CHAR(153) will give aTM(trademark) symbol. However, you may need to experiment with
these beyond character 128.
359
ASCII Code Character
1_
2_
3_
4_
5_
6_
7_ASCII Code Character
8_
9 Horizontal tab
10 Line feed
11 Vertical tab
12 Form feed
13 Carriage return
14 _