MakeString
Returns a text string by concatenating one or more values.
Syntax
MakeString(<values>)
Parameters
<values>
Type: None
A comma-delimited list of values to be concatenated together as a string.
(return)
Type: Text
String that is the concatenation of the values specified in <values>.
Notes
The string arguments can be of any type: each value is coerced to a text value. If no arguments are specified, an empty string is returned.
Example
The following example creates a text string:
Dim A, B
B = CDate("25 January 2002 12:05")
A = MakeString("On ", B.DatePart("d"), "/", B.DatePart("m"))
' A now contains "On 25/1"
See also