CSTR

CSTR(expression)

Returns the expression converted to a string data type (String).

expression

The expression to evaluate and convert to a string,

REMARKS

* The String data type can contain a fixed length or a variable length string.
* If the expression passed to the function is outside the range of the data type being converted to, an error occurs.
* When the expression is a number this function is identical to the STR function.
* If the expression is a boolean it returns the corresponding string representation "True" or "False".
* If the expression can be interpreted as a date it returns a string representation of that date.
* If you convert a Date to a string the resulting string will be formatted according to the "Short Date" predefined format (dd/mm/yyyy).
* If you convert a Date to a string that falls outside the range 1930 - 1999, the format will modify the Short Date slighlty to have a four-digit year instead.
* For numbers its just the value as a string (for example "25").
* You can use the CDATE function to return an expression converted to a Date data type.
* You can use the FORMAT function to return a text string of a date in a particular format.
* You can use the STR function if you want to return a numerical values as a string.
* You can use the STRCOMP function to return the result of a string comparison.
* You can use the STRREVERSE to return a text string with the characters reversed.
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print CStr(100)          '= "100"  
Debug.Print CStr(10 * 10)      '= "100"  

Dim dbValue As Double 
dbValue = 100.1234 
Debug.Print CStr(dbValue)      '= "100.1234"  

dbValue = 0.123 
Debug.Print CStr(dbValue)      '= "0.123"  

Debug.Print CStr("400 pence")  '= "400 pence"  
Debug.Print Str("400 pence")   ' run-time error