MS/Access VBA Library - Christiaan Heidema

Concat

Concatinates multiple string together to one other string without a delimiter.

Syntax

Concat( baseString, stringValue-1 [, stringValue-2 [,...[, stringValue-N]]] )

Parameters

Name	Type	Description
baseString	String	Required. Reference to a String variable. The passed stringvalues are concatinated to this string.
stringValue	Variant	Required. A ParamArray of String expressions which will be concatinated to baseString.

Code

Public Sub Concat(ByRef baseString As String, ParamArray stringValue())
    Dim i As Integer
    For i = LBound(stringValue) To UBound(stringValue)
        baseString = baseString & stringValue(i)
    Next i
End Sub

Stringtag:String