Colapse three memo box into one memo box

[learning_codes]

Hi,

I have three memo box on the form.

Text1
Text2
Text3


Text_Memo = Me.text1 & " " & Me.text2 & " " & Me.text3

I got the result but I don't like it. It shows like: Baseball 5
Teams 20 Players

I'm trying to make it like this:

Baseball
5 Teams
20 Players

Your help would be much appreciated.
Thanks

 

[John W. Vinson]

Hi,

I have three memo box on the form.

Text1
Text2
Text3


Text_Memo = Me.text1 & " " & Me.text2 & " " & Me.text3

I got the result but I don't like it. It shows like: Baseball 5
Teams 20 Players

I'm trying to make it like this:

Baseball
5 Teams
20 Players

Your help would be much appreciated.
Thanks

Why on Earth are you using three textboxes??? Seems like a lot of extra work
compared to one textbox, with its "Enter Key Behavior" property set to "New
line in field".

If you really want to do it this way use

Text_Memo = Me.text1 & vbCrLf & Me.text2 & vbCrLf & Me.text3


On the other hand, if these are really three different KINDS of information -
Sport, NumberOfTeams, NumberOfPlayers - then you should certainly have a Text
field and two Number fields, and no memo fields at all. You can concatenate
the data for display purposes much more easily than you can decompose a
complex, non-atomic memo field.