Chr
Using the Chr Function
In this tutorial you will learn how to use the CHR Function.
The CHR function returns a String containing the character associated with the specified character code.
=CHR( charcode )
charcode the required charcode argument is a Long that identifies a character.
In this example we will work with the number 65.
The result is A.
 Query
The results using a Query would be
 FORM
In a Form you could set the Default Value of a Textbox to
=CHR(65)
 VBA
In a Form add a TEXTBOX control and rename it "txtChr", then you could add the following in the Load Event.
Private Sub Form_Load()
txtAsc = Chr(65)
End Sub
Find a full Table of ASCII characters here.
The opposite of this is the ASC Function.
Course
Want to learn more? Request this via the contact form.
Seminars
Data Encryption
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
