Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Collapse]Rich Text Editor
   [Expand]Product Information
    Product Class Structure
   [Expand]Getting Started
   [Expand]RichEditControl Document
   [Collapse]Fields
    [Expand]Field Codes
    [Collapse]Format Switches
      General Format Switch
      Numeric Format Switch
      Date and Time Format Switch
    Text Formatting
    Import and Export
   [Expand]Page Layout
    Printing
    Spell Checking
    AutoCorrect
    Mail Merge
    Restrictions and Protection
    Syntax Highlighting
    Traversing the Document
   [Expand]Visual Elements
    Services
    Events
    Commands
   [Expand]Member Tables
    Keyboard Shortcuts
    HTML Tag Interpretation
   [Expand]Examples
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

General Format Switch

Expanded Syntax

\* [ " ] switch-argument [ " ]

A general formatting switch specifies formats for a numeric or text result. Quotation marks are required around a switch-argument if it contains a white space; otherwise, they are optional.

Expanded Arguments

The following switch arguments are supported.

Switch Argument Description
ALPHABETIC Formats a numeric result as one or more occurrences of an uppercase alphabetic Latin character. Value 1 results in the letter A, value 2 results in the letter B, and so on up to value 26, which results in the letter Z. For values greater than 26, 26 is repeatedly subtracted from the value until the result is 26 or less. The result value determines which letter to use, and the same letter is repeated for each time 26 was subtracted from the original value. For page 27, the field {PAGE \* ALPHABETIC} results in "AA", as subtracting 26 from 27 results in the value 1, which is represented by the letter A.
alphabetic Formats a numeric result as one or more occurrences of a lowercase alphabetic Latin character. Value 1 results in the letter a, value 2 results in the letter b, and so on up to value 26, which results in the letter z. For values greater than 26, 26 is repeatedly subtracted from the value until the result is 26 or less. The result value determines which letter to use, and the same letter is repeated for each time 26 was subtracted from the original value. For page 80, the field {PAGE \* alphabetic} results in "bbbb" as subtracting 26 from 80 three times results in the value 2, which is represented by the letter b.
arabic Formats a numeric result using Arabic cardinal numerals. For page 123, PAGE \* Arabic results in "123".
arabicdash Formats a numeric result using Arabic cardinal numerals, with a prefix of "- " and a suffix of " -". For page 123, PAGE \* ArabicDash results in "- 123 -".
caps Capitalizes the first letter of each word.
cardtext Formats a numeric result as lowercase cardinal text. For page 123, PAGE \* CardText results in "one hundred twenty-three". Number to text transformation is available for the following languages: English, French, German, Italian, Russian, Swedish, Turkish, Greek, Spanish, Portuguese, Ukrainian, Hindi. The language is determined by the culture of the current thread ( System.Threading.Thread.CurrentThread.CurrentCulture ).
circlenum Formats a numeric result using decimal numbering enclosed in a circle, using the enclosed alphanumeric glyph character for numbers in the range 1 - 20 (Unicode symbols 2460-2473). For non-negative numbers outside this range, formats them as with ARABIC. Note that the font used to display a filed should have corresponding glyphs in the specified positions.
dbchar Formats a numeric result using double-byte Arabic numbering.
dbnum1 Formats a numeric result using ideographic numbers for each digit in decimal representation. The Zero (0) is displayed using the character U+3007 (IDEOGRAPHIC NUMBER ZERO), while other digits are displayed using Chinese numbers from 1 to 9.
dollartext Formats a numeric result in the following form: integer-part-as-cardinal-text and nn/100. The fractional part is rounded to two decimal places and is formatted using Arabic cardinal numerals. The number 123.456 will be displayed as "one hundred twenty-three and 46/100". The dollartext transformation is available for the following languages: English, French, German, Italian, Russian, Swedish, Turkish, Greek, Spanish, Portuguese, Ukrainian, Hindi.
firstcap Capitalizes the first letter of the first word.
gb1 Formats a numeric result using numbers with full stop Unicode characters. Numbers from 1 to 20 correspond to symbols from \u2488 to \u249B.
gb2 Formats a numeric result using parenthesized numbers. Numbers from 1 to 20 correspond to Unicode symbols from \u2474 to \u2487.
gb3 Formats a numeric result using parenthesized ideographs. Numbers from 1 to 10 correspond to Unicode symbols from \u3220 to \u3229.
hex Formats the numeric result using uppercase hexadecimal digits. For page 44, PAGE \* Hex results in "2C"
kanjinum1 Formats a numeric result using Japanese sequential digital ideographs.
lower All letters are lowercase.
MERGEFORMAT

When the field is updated and you apply formatting to the field result, that formatting is retained the next time the field is updated. Usually this works, but since formatting is dependent on the parts of a field result you apply formatting to, there are situations when this switch is unreliable.

The following picture illustrates how the MERGEFORMAT switch works. The MERGEFIELD is bound to the list of writer names. After the field is updated, it shows the first name in the list. We paint the word Arthur red, and then move to the next data record. Red highlighting is retained.

But if we paint the word Conan red, the highlighting will be lost after we navigate the data source to the next record and update the field.

ordinal Formats a numeric result using lowercase ordinal Arabic numerals. Ordinal conversion is available for the following languages: English, French, German, Italian, Russian, Swedish, Turkish, Greek, Spanish, Portuguese, Ukrainian. The language is determined by the culture of the current thread ( System.Threading.Thread.CurrentThread.CurrentCulture )
ordtext Formats a numeric result as lowercase ordinal text. The fractional part is used to round off the whole number part and then discarded. Ordinal conversion is available for the following languages: English, French, German, Italian, Russian, Swedish, Turkish, Greek, Spanish, Portuguese, Ukrainian, Hindi. The language is determined by the culture of the current thread ( System.Threading.Thread.CurrentThread.CurrentCulture ).
ROMAN Formats a numeric result using uppercase Roman numerals.
roman Formats a numeric result using lowercase Roman numerals.
sbchar Formats a numeric result using common, single-byte Arabic numbering.
upper Capitalizes all letters.
zodiac1 Formats a numeric result using sequential numerical ideographs.
zodiac2 Formats a numeric result using sequential numerical ideographs.
zodiac3 Formats a numeric result using sequential numerical ideographs.

How would you rate this topic?​​​​​​​