MakeString
Returns a text string by concatenating one or more values.
Syntax
MakeString([Vals, ...])
Parameters
Vals
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 Vals.
Remarks
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
This example shows using the MakeString function to create 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