Concatinate TextBoxes into 1 TextBox, use Return Character

I

I Love Xbox

I'm trying to concatenate 3 text boxes into 1 textbox. I also want the
values to be seperated by a Return Character. I tried to use "vbCr" but I
get square blocks. I also tried to use char(13) but got errors too. Anyone
got any ideas?

Thanks in Advance!
 
J

Jedit

Try
set the control source of the text box you are setting to
=[Yourtxtbox1]&" "&[Yourtxtbox2]&" "&[Yourtxtbox3]
replace the Yourtxtbox# between the brackets for the names of the apropriate
boxes you are joining together.
hope this helps
 
Top