Address label copybox

[JChandler22]

I have a customer contact database, and a form that shows records for each customer including name, address, city, state, zip, country, phone, etc, all in separate fields of course.

I would like to create another field on the form that takes the data from all of those fields and constructs an address label, then below the field I will have a button to copy the address to the clipboard to be used elsewhere. So if the fields are:

First Name: John
Last Name: Smith
Address: 12345 Charles St.
City: Boston
State: MA
Zip: 02136

Then I want another field in that same form to compile all of those a produce:

John Smith
12345 Charles St.
Boston, MA 02136

Suggestions? Many thanks!

 

[Rabbie]

First Name: John
Last Name: Smith
Address: 12345 Charles St.
City: Boston
State: MA
Zip: 02136

Then I want another field in that same form to compile all of those a produce:

John Smith
12345 Charles St.
Boston, MA 02136

Air code for this bit

dim label as string
label = [first name] & " " & [last name] & vbcrlf & [address] & vbcrlf  & [city] & "," & [state] & " " & [zip]

 

[JChandler22]

Thanks for the suggestion, but I'm starting to get it without using vb.

I've just made a text box and I'm trying to use expression builder to form the address.

How do you insert a line break in expression builder?

 

[Rich]

Something like
=[FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & IIf(IsNull([City]),"",[City] & Chr(13) & Chr(10)) & [PostalCode]

 

[JChandler22]

Perfect. Thanks!