Using the ASC Function
In this tutorial you will learn how to use the ASC Function.
The ASC function returns an Integer representing the character code corresponding to the first letter in a string.
=ASC( string )
string the value you wish to convert
In this example we will work with the letter 'A'.
The result is 65.
In a Form you could set the Default Value of a Textbox to
In a Form add a TEXTBOX control and rename it "txtAsc", then you could add the following in the Load Event.
Private Sub Form_Load()
txtAsc = Asc("A")
Find a full Table of ASCII characters here.
The opposite of this is the CHR Function.
Want to learn more? Request this via the contact form.
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips