BUG: TRIM() Function in dBASE Label Is Not Migrated

• Microsoft FoxPro for MS-DOS, version 2.6
• Microsoft FoxPro for Windows, version 2.6

SYMPTOMS

When printing a label migrated from dBASE IV, there are extra spaces between fields.

CAUSE

When FoxPro migrates the label, it does not add the TRIM() function to the character fields that had the "T" picture function in dBASE.

RESOLUTION

Modify the FoxPro label and use the TRIM() function on each field on which the trailing spaces should be removed.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

1. In dBASE IV, create a label with the following layout:

         XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  && field: company name
         XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  && field: address
         XXXXXXXXXXXXXXX, XX  XXXXX           && fields: city, state, zip
   
      By default each of the character fields will have the picture function
      "T", which is the TRIM function code to remove trailing spaces.
   
   

2. In FoxPro 2.6, choose Convert dBASE files from the Run menu. Select the directory where the above label was saved, double-click the label to mark it, and then choose Process. When the migration is complete, choose Close.

3. Modify the label. The following will be the label definition:

         COMPANY
         ADDRESS
         CITY+","+" "+STATE+"  "+ZIP
   

To correct this problem, the label definition should be:

   TRIM(company)
   TRIM(address)
   TRIM(city)+","+" "+TRIM(state)+"  "+TRIM(zip)