Converts the first character of a string to its Unicode code point. A Unicode code point is the numerical integer value given to a Unicode character.
Asc ( string )
|string||The string for which you want the code point value of the first character.|
Data type : integer
Returns the code point value of the first character in string.
Use Asc to test the case of a character or manipulate text and letters.
To find out the case of a character, you can check whether its code point value is within the appropriate range.
This expression returns the string in [MyField] if the code point value of the first character in [MyField] is A (65):
If (Asc([MyField]) = 65, [MyField], ‘Not a valid code’)