Column Properties

Display Properties (Masks)

! Upper Case
^ Lower Case
a Alphanumeric
x Any character
# Number

Sample format	5	-5	.5
[General]	5	-5	0.5
0	5	-5	1
0.00	5.00	-5.00	0.05
#,##0	5	-5	1
#,##0.00	5.00	-5.00	0.50
$#,##0;($#,##0)	$5	($5)	$1
$#,##0;-$#,##0	$5	-$5	$1
$#,##0;[RED]($#,##0)	$5	($5)	$1
$#,##0.00;($#,##0.00)	$5.00	($5.00)	$0.50
$#,##0.00;[RED]($#,##0.00)	$5.00	($5.00)	$0.50
0%	500%	-500%	50%
0.00%	500.00%	-500.00%	50.00%
0.00E+00	5.00E+00	-5.00E+00	5.00E-01

Code Tables

· CheckBox

· Dropdown DataWindow

· Dropdown listbox

· Edit

· Radio button

· Edit mask

To obtain the display value of a code table from script, use LookUpDisplay( )

Note checkbox for Validate using Code Table needs to be selected to require a match in code table.

Edit mask

For job number use the following edit mask: !!-!!!!-!

Required DataWindow Columns

this is a check box on the edit tab ItemError event fired if user attempts to tab off a required column without entering data.

If the user does not place the focus on a column, no check is performed. If possible, use FindRequired( ) to check for Nulls in required columns before Update( ).