DOCUMENT:Q143063  26-AUG-1999  [foxpro]
TITLE   :How to Remove White Lines in Mailing Labels and Reports
PRODUCT :Microsoft FoxPro
PROD/VER:3.00 3.00b
OPER/SYS:
KEYWORDS:

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b 
-------------------------------------------------------------------------------

SUMMARY
=======

When doing mailing labels, companies often have multiple address lines for
company Name, P.O. Box, Address1, Address2, City, State, and Zip. At times some
of these lines may be blank if a customer does not have a P.O. Box or has only
one address line. The steps in this article demonstrate how to remove blank
lines (white space) from the report or mailing label without using the float
option. The float option on an Invoice report causes the header section to
shrink and grow with the number of lines being printed.

MORE INFORMATION
================

Step-by-Step Example
--------------------

1. Create a table called Mylabel.dbf that contains five fields representing
   address lines called line1, line2, line3, line4, and line5.

2. Create a label called Mylabel.lbx by using the Label Wizard.

3. In the area of the report where the label would normally be, delete all the
   label text boxes. Then add one text box called Text1, and make it five lines
   high.

4. In the expression of the text box, enter:

      line1; line2; line3; line4; line5

5. Choose Print When, and select Remove Line If Blank. This will arrange the
   lines properly and remove any blank lines from the individual address lines.

6. Save the label as Mylabel.lbx.

7. Add six records to the table Mylabel.dbf leaving none, one, or two lines
   blank in each record. Do not leave line1 blank.

8. Preview the Label. It should produce a report without any blank lines in the
   address and the height of the header section should stay the same.

Additional query words: VFoxWin blank line

======================================================================
Keywords          :  
Technology        : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b
Version           : 3.00 3.00b

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1999.