How to Format a Numeric Field in a Text MergeID: Q101000 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 |