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.
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