ID: Q139000
2.60a WINDOWS kbtool kbbuglist kbfixlist
The information in this article applies to:
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.
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,"")
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.
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
Last Reviewed: October 31, 1998