Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/101000

From BetaArchive Wiki

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
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.