Microsoft KB Archive/101000
How to Format a Numeric Field in a Text Merge
The information in this article applies to:
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