concatenating textboxes into label

[teachnmyself]

I need to combine 7 textboxes into 1 label. I have tried the following code but it only combines the first 2 boxes. I dont understand why it wont do all 7. Im putting this code in

private sub textbox1_change

label1.caption = textbox1.text & textbox2.text & textbox3.text....(and so on until textbox7.text)

end sub

I have tried .text and .value. they both give me the same result but not a successful chain of words.
Can someone tell me what i'm doing wrong

 

[Case_Germany]

Hi,

try the following codes:

Private Sub CommandButton1_Click()
    Dim intTMP As Integer
    Label1.Caption = ""
    For intTMP = 1 To 7
        Label1.Caption = Label1.Caption & Controls("TextBox" & intTMP).Text & vbCrLf
    Next intTMP
End Sub

Or change:

Label1.Caption = Label1.Caption & Controls("TextBox" & intTMP).Text

Label1.Caption = Label1.Caption & Controls("TextBox" & intTMP).Text & " "

Label1.Caption = Label1.Caption & Controls("TextBox" & intTMP).Text & ","

The label must be naturally large enough, in order to indicate the texts.

Case_Germany