Learn how to use the Access Str function with syntax and examples.
The Microsoft Access Str function returns a string representation of a number.
The syntax for the Microsoft Access Str function is:
Str ( number )
number is the value to convert to a string.
The Str function can be used in the following versions of Microsoft Access:
Str (12) Result: " 12" Str (450) Result: " 450"
The Str function can be used in VBA code in Microsoft Access. For example:
Dim LResult As String LResult = Str (16)
In this example, the variable called LResult would now contain the value " 16".
You can also use the Str function in a query in Microsoft Access.