R
robertguy
Dave,
I've amended my code to :-
Me.TextBox1.Value = .Offset(myIndex, 1).Value & vbNewLine _
& .Offset(myIndex, 2) & vbNewLine & .Offset(myIndex, 3)
and
Me.TextBox1.Value = .Offset(myIndex, 1).Value & vblf _
& .Offset(myIndex, 2) & vblf & .Offset(myIndex, 3)
and changed :-
WordWrap = True
.MultiLine = True
.EnterKeyBehavior = True
But unfortunately it is still displaying the text on one line withou
inserting a new line !!
Any Ideas ?
Ro
I've amended my code to :-
Me.TextBox1.Value = .Offset(myIndex, 1).Value & vbNewLine _
& .Offset(myIndex, 2) & vbNewLine & .Offset(myIndex, 3)
and
Me.TextBox1.Value = .Offset(myIndex, 1).Value & vblf _
& .Offset(myIndex, 2) & vblf & .Offset(myIndex, 3)
and changed :-
WordWrap = True
.MultiLine = True
.EnterKeyBehavior = True
But unfortunately it is still displaying the text on one line withou
inserting a new line !!
Any Ideas ?
Ro