FIX: Detail Band Height Not Adjusted for Memo Using Print When

ID: Q139000

2.60a WINDOWS kbtool kbbuglist kbfixlist

The information in this article applies to:

Microsoft FoxPro for Windows, version 2.6a

SYMPTOMS

The band height for Detail bands does not adjust properly when an expression is entered in the Print When dialog box for a memo field. In FoxPro 2.6a for Windows, if the expression in the Print When dialog box evaluates to false for a record, the Detail band has the same height as the Detail band for the previous record. The height of the Detail band should decrease because no memo field is printing. This problem does not occur in Visual FoxPro.

WORKAROUND

If the memo field in the only field printing in the Detail band, remove the expression in the Print When dialog box, and select "Remove line if Blank" instead. Replace the memo field name in the field expression with:

   IIF(!empty(memofld),memofld,"")

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual FoxPro version 3.0 for Windows.

MORE INFORMATION

Steps to Reproduce Problem

1. Create a table containing two fields - a character field named charfld

   and a memo field named memfld.

2. Enter three records. The character field for records 1, 2, and 3 should

   contain a, b, and a respectively.

3. Place a relatively long memo field in the first record and a short memo

   field in the second and third records.

4. Create a new report, and place the text and memo fields on the report.

   Select "Field Can Stretch" in the expression for the memo field. Select
   the Print When dialog box, and enter "charfld='a'" without the quotation
   marks in the text box.

5. Print Preview the report. In FoxPro 2.6a for Windows, the second

   record's Detail band is the same height as the first record's Detail
   band even though the memo field is not printing.

Additional reference words: 2.60a FoxWin VFoxWin fixlist3.00 buglist2.60a KBCategory: kbtool kbbuglist kbfixlist KBSubcategory: FxotherGeneral

Keywords          : FxotherGeneral kbbuglist kbfixlist
Version           : 2.60a
Platform          : WINDOWS
Solution Type     : kbfix