DOCUMENT:Q250981  20-MAY-2000  [foxpro]
TITLE   :PRB: Merged FoxPro Table Fields Display Incorrectly in Word
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:3.0,3.0b,5.0,5.0a,6.0
OPER/SYS:
KEYWORDS:kbDatabase kbvfp300 kbvfp300b kbvfp500 kbvfp500a kbvfp600 KbDBFDBC kbWord kbGrpDSFox kb

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a, 6.0 
-------------------------------------------------------------------------------

SYMPTOMS
========

The Mail Merge feature of Microsoft Word does not properly display numeric and
currency fields that are merged from Microsoft Visual FoxPro tables.

RESOLUTION
==========

To display merged numbers correctly, you must use Format Masking. To format the
results of a mail merge, you must use the numeric picture switch in the
MERGEFIELD field code as shown here:

1. Open the main document in Microsoft Word.

2. Display the field codes by pressing ALT+F9.

3. For all the merge fields that display numeric or currency fields, which do
   not have decimal places, change the field code as follows:

{ MERGEFIELD fieldname \# #,###,###.00 }

4. Press ALT+F9 to toggle the view to show field results instead of field codes.

5. Run the merge again to a new document to get the correct results.

MORE INFORMATION
================

If the merged numeric and currency fields do not have any decimal values, they
display with only a decimal point to the right of them. For example "12345.00"
displays as "12345.".

Steps To Reproduce Behavior
---------------------------

1. Run Visual FoxPro. Create and populate a table as follows:

      CREATE TABLE MrgTest (Fld1 c(5), Fld2 n(8,2), Fld3 y)
      INSERT INTO MrgTest VALUES("AAAAA", 12345.11, 2345.11)
      INSERT INTO MrgTest VALUES("BBBBB", 67890.00, 6789.00)

2. Close the table and then close Visual FoxPro.

3. Make sure that Microsoft Query is installed on your computer by searching for
   Msqrv32.exe on your computer. If Microsoft Query is not installed, then run
   the Microsoft Office setup to install Microsoft Query.

4. Use the ODBC Manager and create a data source based on the Microsoft Visual
   FoxPro ODBC Driver for the Visual FoxPro table you created in the first step.
   Name the data source VFPMrgTest.

5. Run Microsoft Word and open a new document. From the Tools menu, click Mail
   Merge to open the Mail Merge Helper dialog box.

6. In the Mail Merge Helper dialog box, click the Create command button and then
   click the document type that you want. In the next dialog box, click the
   Active Window command button.

7. In the Mail Merge Helper dialog box, click the Get Data command button, and
   then click Open Data Source.

8. In the Open Data Source dialog box, in the Files of type combo box click "MS
   FoxPro Files". Locate the Visual FoxPro table you created in the first step
   and highlight the table name. Click the Open command button in the bottom
   right corner of the Open Data Source dialog box.

9. In the Confirm Data Source dialog box, click "FoxPro File - Word via
   ODBC(*.dbf)", and then click OK. In the next dialog box, click Set Up Main
   Document. In the Label Options dialog box, select the label type and then
   click OK.

10. Click the Insert Merge Fields command button and insert all the fields in
   the table from the Create Labels dialog box and then click OK.

11. In the Mail Merge Helper dialog box, click Merge. In the Merge dialog box,
   click New Document as the "Merge To" option and then click Merge.

Note that the numeric and currency fields that do not have decimal values display
incorrectly. For example "6789.00" shows as "6789."

REFERENCES
==========

For additional information on setting up a DSN, click the article number below
to view the article in the Microsoft Knowledge Base:

   Q186086 HOWTO: Get a File DSN in the Connection Designer

Additional query words:

======================================================================
Keywords          : kbDatabase kbvfp300 kbvfp300b kbvfp500 kbvfp500a kbvfp600 KbDBFDBC kbWord kbGrpDSFox kbDSupport kbword2000 kbCodeSnippet 
Technology        : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b kbVFP500 kbVFP600 kbVFP500a
Version           : WINDOWS:3.0,3.0b,5.0,5.0a,6.0
Issue type        : kbprb

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2000.