I'm creating an invoice report. I have a text box that I want to display the address in. I have the normal fields in my database for address:
Address1
Address2 (optional)
City
State
Zip
I want the the formated text to look like this
{Address 1}
{Address 2} if there is data in the field else move 3rd line to this line
City, State Zip.
How can I format the text box to display my address in this fashion?
Thanks!
Address1
Address2 (optional)
City
State
Zip
I want the the formated text to look like this
{Address 1}
{Address 2} if there is data in the field else move 3rd line to this line
City, State Zip.
How can I format the text box to display my address in this fashion?
Thanks!