Daffodil Computers Ltd.
Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:18:20 PM
-
Function: Join()
Purpose: The join() function takes an array of strings and an optional delimiter as arguments and returns a single string that contains each string from the input array, separated by the delimiter (if applicable).
Usage: IsError(array, [delimiter])
Returns: Concatenated string
Example:
Dim MyString() As String = {"Eat", "Pray", "Love"}
Dim ResultString As String = Join(MyString, ", ")
In this example, ResultString would contain "Eat, Pray, Love"