Formatting a Text Box

[Crackers]

I have a Text Box on a Form that copies the data entered into other text boxes on the same form. (i.e =[NAME] & [ADDRESS] & [PHONE]).
When the data goes into the main Text box it appears as such:
BillSmith1HappyStreet5556159
How can I put spaces between the different fields, and can I start each field on a different line of the text box.
Anybody that can help, I would be very thankful for your assistance.

 

[maxmangion]

=[name] & " " & [address] & " " & [phone]

 

[Rich]

i.e =[NAME] &" " & [ADDRESS] & " " &[PHONE]).

 

[maxmangion]

by the way, i just noticed that you have a field called Name ... it is not ideal using that word for a fieldname, try replacing it with FirstName or LastName for example.

 

[Rich]

and we also missed that you want each field to start on a new line

=[SomeNAME] & Chr(13) & Chr(10) & [ADDRESS]& Chr(13) & Chr(10)&[PHONE]

 

[maxmangion]

and we also missed that you want each field to start on a new line

you're right Rich, i've missed it too

 

[kupe]

Like this start on a new line, Rich. I'll borrow that if I may. Cheers

=[SomeNAME] & Chr(13) & Chr(10) & [ADDRESS]& Chr(13) & Chr(10)&[PHONE]). [/QUOTE]