Template Property Builder dialog box, Numeric page

Build a template that determines what characters will be allowed in the selected text component. Choose one of the three tabs: Character, Numeric, or Date.

The Numeric page lists symbols for formatting numeric data in the selected field.

For example, if you want the text to be limited to 3 digits, a decimal, and 2 digits to the right of the decimal (nnn.nn):

1. Click the Numeric tab

2. Double-click 9 three times

3. Double-click the period once

4. Double-click the 99 twice more (999.99).

Characters typed in the text component are formatted such that typing 456789 displays 456.78.

Template Symbols and Format Functions

Displays the symbols you can enter in the Template box that apply to numbers.

Symbol Description

Space The format of the template must be Function codes separated from Picture
 codes by a space.

@( Encloses negative numbers in parentheses.

@$ Displays a currency character before, or after, the value. The currency
 character and it's position are determined by SET CURRENCY
 LEFT | RIGHT.

@B Left justifies a numeric value.

@C Displays CR (credit) after a positive number.

@I Centers the value.

@J Right justifies the value.

@L Displays zeros before the value.

@X Displays DB (debit) after a negative number.

@Z Displays spaces rather than zeros if the value is 0.

@^ Displays the value in scientific notation.

9 Restricts input to a number for a character value. Restricts
 input to a number, +, -, decimal point or other SET
 POINT character.

$ Same as 9 but displays the currency character in all blank
 positions before the numeric value.

* Same as 9 but displays an asterisk in all blank positions
 before the numeric value.

, Inserts a comma in the thousands place.

. Inserts a decimal point, or other SET POINT character, in
 this position.

The currency character and it's position (left or right) are set by the Currency Symbol and Currency Position options on the Country page of the Desktop Properties dialog box.

The $ or * picture codes behave similar to 9 in a numeric picture string. Any * picture code in the string will override any $ picture code in the string.

For example;

How to get there: In the Inspector click the wrench tool beside the function property (in the Edit category).