Help formatting a text box

  • Thread starter Thread starter Will Sellers
  • Start date Start date
W

Will Sellers

I have a form that contains customer name address city state zip fields
I want to create a text box that contains these fields appearing like this
customer name
address
city state zip

I need this text box so that a user can copy and paste into a label printing
program
 
I have a form that contains customer name address city state zip fields
I want to create a text box that contains these fields appearing like this
customer name
address
city state zip

I need this text box so that a user can copy and paste into a label printing
program
Click to expand...

In an Unbound text control:

=[CustomerName] & chr(13) & chr(10) & [Address] & chr(13) & chr(10) &
[City] & ", " & [State] & " " & [Zip]
 
Thanks
This was exactly what I wanted.


--
For a great shopping experience check out
www.willselldealoftheday.com
fredg said:
I have a form that contains customer name address city state zip fields
I want to create a text box that contains these fields appearing like this
customer name
address
city state zip

I need this text box so that a user can copy and paste into a label printing
program
Click to expand...

In an Unbound text control:

=[CustomerName] & chr(13) & chr(10) & [Address] & chr(13) & chr(10) &
[City] & ", " & [State] & " " & [Zip]
Click to expand...
 
Back
Top