Access/VBA Library

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