Combine names and address in a textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help on how to combine name fields and address in a texbox as follow:

John Doe
1234 Anytown Street
Any City, AnyState 00000-0000

Your suggestions will be highly appreciated!
 
I'd use three text boxes....

=[FirstName] & " " & [LastName]
=[Address]
=[City] & ", " & [State] & " " & [ZipCode]
 
Sokan33 said:
I need help on how to combine name fields and address in a texbox as
follow:

John Doe
1234 Anytown Street
Any City, AnyState 00000-0000

Your suggestions will be highly appreciated!
Click to expand...

=[FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] & Chr(13) &
Chr(10) & [City] & ", " & [State] & " " & [ZipCode]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting address fields 4
combine info into 1
Physical Address and Mail Merge 5
Combining Information 2
Excel 2000 - Split Contents of Cell Across Multiple Cells 7
combine PARSED STRINGS 6
how to combine 2 fields: i.e. (house# + street)=(new)address 4
Pulling the town out of an address 5

Back
Top