ToText(value)

Returns a text value containing the printed representation of the input value.

Parameters

value

The value you want to convert to text.

Returns

Text

Remarks

If the input value is null, the function will return null.

For converting Numeric, Date, Time, and Timestamp values, consider using the Format function instead.

Examples

• ToText([Date Column]) takes the date value "25/3/2013" stored in the Date Column and returns it as the text type value "2013-03-25".
• ToText([Timestamp Column]) takes the timestamp value "25/03/2013 10:51:34 AM" stored in the Timestamp Column and returns it as the text type value "2013-03-25 10:51:34".
• ToText([Time Column]) takes the time value "10:15 AM" stored in the Time Column and returns it as the text type value "10:15:00".
• ToText([Duration Column]) takes the duration value "30 minutes" stored in the Duration Column and returns it as the text type value "00:30:00".
• ToText([Record Owner]) takes the user type value and returns the email address of the user stored in the Record Owner column.
• ToText(true) returns "1".
• ToText(false) returns "0".
• ToText(10) returns "10.000000".