Microsoft KB Archive/116273

{| = BUG: Remove Line When Blank Does Not Work with General Field =
 * width="100%"|

ID: Q116273

The information in this article applies to:


 * Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a

SYMPTOMS
If the Print When check box is selected in the Report Expression dialog box and the Remove Line When Blank check box is selected in the Print When dialog box, the general field prints several blank lines when the general field is blank.

With character or numeric fields, selecting these check boxes would cause the blank field to be removed.

RESOLUTION
1. Double-click the general field in the report.

2. In the Report Expression dialog box, select the Print When check box.

3. In the Print When dialog box, select the Remove Line When Blank check

box. 4. Select the Print Only When Expression Is True check box. 5. In the Expression Builder dialog box, enter the following expression

!empty

where is the name of the general field in the database. 6. Choose OK three times to return to the Report Layout window. 7. From the Report menu, choose Page Preview. Note that the empty general

field has been removed.

STATUS
Microsoft has confirmed this to be a problem in FoxPro versions 2.5, 2.5a, 2.5b, and 2.6 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional reference words: FoxWin RWriter 2.50 2.50a 2.50b 2.60 2.60a buglist2.50 buglist2.50a buglist2.50b buglist2.60 buglist2.60a KBCategory: kbtool kbprint kbui kbbuglist KBSubcategory: FxtoolRwriter
 * }