A script-enabled browser is required for this page to function properly.

About Formatting Text Item Values with Format Masks

You can format numbers and Dates in single-line text items with format masks. When a format mask is assigned to a text item, any value entered by the end user or fetched or assigned to the item is displayed in the format specified by the mask.

The following example shows how a format mask affects a NUMBER value:

Format Mask

Fetched Value

Displayed Value

$9,999,999.99

3246000

$3,246,000.00

A format mask can also be used to automatically embed special characters, such as dashes and monetary symbols, in values entered by end users.

Format Masks and Data Types

A format mask can be applied to text items with the following data types:

The format mask must be compatible with the data type of the text item. For example, the following format mask can be used only with a DATETIME text item because only this type has both the Date and time information that this format mask requires:

Format Mask

Displayed Value

DDfmMONTH YYYY HH:MI

12 JUNE 1994 12:32

 


Assigning a format mask to a text item

Text item format mask symbols for NUMBER values

Text item format mask symbols for DATE values

Format Mask property