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!
  • Students Click Here

*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


Suppressing a Blank field

Suppressing a Blank field

Suppressing a Blank field


i am creating a letterhead and i am having issues with the to address.

the database has following fields:

Address Line 1
Address Line 2
City, State, Zip

The issue i am facing is that not all the tenants have address line 2 populated. So how do i suppress it that if there is some thing in line 2 then it expands to include line 2 other wise only shows what's populated.

right now even though line 2 is not visible because there is no text in it but its still occupying that space unde address line 1 and showing up as a blank box.

should i create a subreport for address?

RE: Suppressing a Blank field

Create additional detail sections - A, B, C, and D. Put the fields in the appropriate sections, then in the section expert click 'suppress blank section'.

RE: Suppressing a Blank field

If I recall correctly ( it has been a while), if you create a text box and place the fields in it, it can be formatted to suppress when blank ( I used it all the time for address labels)


To Paraphrase:"The Help you get is proportional to the Help you give.."

RE: Suppressing a Blank field

its seems like a good idea...but it didnt work...the space is still visible. I just created multiple sections and thats working best for me right 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!

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