Microsoft Access Function Library: Join()

[bbasujon]

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"