How to Format a Numeric Field in a Text Merge

ID: Q101000

The information in this article applies to:

Microsoft FoxPro for Windows, versions 2.5 and 2.5a
Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a

Using a text merge, you can format a numeric field differently than it appears in the database--for example, including commas, dollar signs, decimal points, and so on when the field is viewed in output.

The following sample code shows how to format a numeric field in a text merge:

   SET TEXTMERGE ON
   SET TEXTMERGE DELIMITERS TO
   USE dbf_file
   SCAN
      TEXT
      <<TRANSFORM(<fieldname>,'9,999.99')>>
      *After the transform the number 1234 would look like 1,234.00
      ENDTEXT
   ENDSCAN

Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a textmerge number currency KBCategory: kbprg KBSubcategory: FxprgGeneral

Last Reviewed: June 27, 1995