BUG: Remove Line When Blank Does Not Work with General Field

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.

5. In the Expression Builder dialog box, enter the following expression

      !empty(<gen>)

   where <gen> is the name of the general field in the database.

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.