hello guys
i have multiple textboxes in Report Detail and every textbox contain different data am having a problem when turn cangrow on so i decide to put all the textbox in one textbox but am not getting any data
this is my code please can someone help me to fix it
i have multiple textboxes in Report Detail and every textbox contain different data am having a problem when turn cangrow on so i decide to put all the textbox in one textbox but am not getting any data
this is my code please can someone help me to fix it
Code:
If Me.txt3 = "" Then
Me.txt_Combination = Me.txt1 & vbCrLf & Me.txt2 & vbCrLf & Me.txt4 & vbCrLf & Me.txt5 & vbCrLf & Me.txt6 & vbCrLf & Me.txt7 & vbCrLf & Me.txt8
ElseIf Me.txt6 = "" Then
Me.txt_Combination = Me.txt1 & vbCrLf & Me.txt2 & vbCrLf & Me.txt4 & vbCrLf & Me.txt5 & vbCrLf & Me.txt3 & vbCrLf & Me.txt7 & vbCrLf & Me.txt8
ElseIf Me.txt3 = "" And Me.txt6 = "" Then
Me.txt_Combination = Me.txt1 & vbCrLf & Me.txt2 & vbCrLf & Me.txt4 & vbCrLf & Me.txt5 & vbCrLf & Me.txt7 & vbCrLf & Me.txt8
End If