If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to eliminate blank lines on a report?
I have a report that is used for creating and printing labels. The report
pulls info from 1 table and lists the field info on a report - 1 record for each label. The fields that are being displayed are for example, First Name, Last Name, Email and Phone. Every one of the recipients have a first and last name and phone, but not all have an email address. How would I eliniate the blank line produced by a null value in a recipients email address so that it doesn't make my label look like it is missing something. I thought it was can shrink or something like that, but it doesn't seem to work. Thanks, |
#2
|
|||
|
|||
How to eliminate blank lines on a report?
Try and set the Can grow property of the field and the section where the
field is located in to Yes. -- \\// Live Long and Prosper \\// BS"D "dwalsh77" wrote: I have a report that is used for creating and printing labels. The report pulls info from 1 table and lists the field info on a report - 1 record for each label. The fields that are being displayed are for example, First Name, Last Name, Email and Phone. Every one of the recipients have a first and last name and phone, but not all have an email address. How would I eliniate the blank line produced by a null value in a recipients email address so that it doesn't make my label look like it is missing something. I thought it was can shrink or something like that, but it doesn't seem to work. Thanks, |
#3
|
|||
|
|||
How to eliminate blank lines on a report?
"dwalsh77" wrote in message
... I have a report that is used for creating and printing labels. The report pulls info from 1 table and lists the field info on a report - 1 record for each label. The fields that are being displayed are for example, First Name, Last Name, Email and Phone. Every one of the recipients have a first and last name and phone, but not all have an email address. How would I eliniate the blank line produced by a null value in a recipients email address so that it doesn't make my label look like it is missing something. I thought it was can shrink or something like that, but it doesn't seem to work. Thanks, For the Detail section of the label, set: Can Grow = No Can Shrink = No For the top line (text box), set: Can Grow = No Can Shrink = No For all but the top line (text box), set: Can Grow = No Can Shrink = Yes -- --------------------------------------------------------------- Michael J. Strickland Quality Services 703-560-7380 --------------------------------------------------------------- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Blank lines in report output (to text file) | Harry V | Setting Up & Running Reports | 2 | December 8th, 2005 06:47 PM |
Blank lines in a report | Sparky | General Discussion | 3 | November 30th, 2005 06:57 AM |
How to eliminate line-breaks but preserve blank lines? | Joseph Geretz | Formatting Long Documents | 2 | November 20th, 2005 04:20 AM |
Printing Reports Access 2002 Pleas Advise | Dermot | Database Design | 12 | October 5th, 2005 11:23 AM |
Unwanted Blank Lines in Report | Christen | Setting Up & Running Reports | 1 | July 8th, 2004 09:54 AM |