×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Name& Address: How to write display formula

Name& Address: How to write display formula

Name& Address: How to write display formula

(OP)
Hope someone can help...

I have several fields from a database I need to write as a name and address in a form letter.  The fields are:
Name
Addr1
Addr2
City
State
Zip

My first question is, how can I write a formula to include all of these fields with carriage returns between them, so they don't all run together in one line?

The secons question:  Sometimes Addr 1 or Addr2 is blank.  If so I want to omit it and not show a blank row in the printed address. How can I do that?

Any help is greatly appreiciated.

Thanks

Craig

RE: Name& Address: How to write display formula

Dear Craig,

You dont need a formula, but what you need to do is create a blank text object (label), and insert each database field, one at a time, by dragging them into the text object.

First, drag the name in, then put in a carriage return, add1, then another carriage return, add2, etc.

When you have finished that, right click on the text object containing all these fields, and choose edit text object.  Then with your pointer, click on each individual item, one at a time to highlight, then a right click a second time to choose format{database field}.

In the common tab - down the bottom, there should be a suppress if blank tick box - tick it for each.

Then if there is no add2 - it will skip it and not produce a blank.

Cheers,

paulmarr@arcom.com.au

RE: Name& Address: How to write display formula

(OP)
Thanks, your tip really did the trick!  Everything seems to be working great now.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close