Combine fields into one

[cotri]

I have a form for taking orders and would like to combine [Customer Name], [Address], [City], [State], and [Zip Code] into one field so it can copy the complete name/address and then paste it into another application. The final “combo” field would have to be similar to how a normal address would be printed.

Customer Name
Address
City, State. Zip Code.



The name and address each on their own lines and city, state and zip code on one line with a coma after city.

Any Ideals? Thanks

[maximus]

Let me get you straight that you have a Form with the following field Text Boxes: [Customer Name], [Address], [City], [State], and [Zip Code]

Now you want them to be arranged like this:

Customer Name
Address
City, State. Zip Code.


Create a text box on the form

Type the following code in the Control Source of the text box

=[Customer Name] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & [City] & ", " & [State] & ". " & [Zip Code]

Please mark the thread solved if this solves your problem.

[cotri]

Worked perfectly…Thanks so much