This is a migrated thread and some comments may be shown as answers.

Help formating fields in text box

0 Answers 111 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Brad Williams
Top achievements
Rank 1
Brad Williams asked on 16 Mar 2010, 10:37 PM
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!

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
Brad Williams
Top achievements
Rank 1
Share this question
or