Syntax

CStr(expression)

Description

Converts expression to a String.

Comments

Unlike Str$ or Str, the string returned by CStr will not contain a leading space if the expression is positive. Further, the CStr function correctly recognizes thousands and decimal separators for your locale.

Different data types are converted to String in accordance with the following rules:

Data Type

CStr Returns

Any numeric type

A string containing the number without the leading space for positive values.

Date

A string converted to a date using the short date format.

Boolean

A string containing either TRUE or FALSE.

Null variant

A runtime error.

Empty variant

A zero-length string.

Example

This example displays the value of a Double converted to a String.

Sub Main()

  s# = 123.456
  MsgBox "The string value is: " & CStr(s#)
End Sub

See Also

CCur (function); CBool (function); CDate, CVDate (functions); CDbl (function); CInt (function); CLng (function); CSng (function); CVar (function); CVErr (function); String (data type); Str, Str$ (functions).

C