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

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.