Microsoft KB Archive/139000

{| = FIX: Detail Band Height Not Adjusted for Memo Using Print When =
 * width="100%"|

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.

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
 * }