MS Access: Chr Function
The Microsoft Access Chr function returns the character based on the NUMBER code.
Chr Function (Syntax)
The syntax for the Chr function is:
Chr ( number_code )
number_code is the NUMBER used to retrieve the character.
The Chr function can be used in the following versions of Microsoft Access:
- Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000
|Chr (87)||would return "W"|
|Chr (105)||would return "i"|
Chr Examples (in VBA Code)
The Chr function can be used in VBA code in Microsoft Access. For example:
Dim LResult As String LResult = Chr (87)
In this example, the variable called LResult would now contain the value "W".
Chr Examples (in SQL/Queries)
You can also use the Chr function in a query in Microsoft Access.