Input Masks

Under Construction

Input mask type

Available in Form Section and Canvas Section fields. Fields must have a known width, i.e. bound to a field from a table or to a memory variable with a default value set. Select from the listed options. This will populate the mask as follows:

Type	Mask
Custom	Not populated.
Currency	@C2
Date	@D
Email Address	@E
Number	@F
Text	@X
Time	@T
Alphabetic	@A
Upper Case	@!
Upper Case Alphabetic	@^

Custom input masks

Mask	Description
@C, @C2, @C4	Currency: the digit is the number of decimal places
@D	Date: ISO date YYYY-MM-DD
@E	Email:
@F	Number:
@X	Text: accept alphanumeric characters
@T	Time:
@A	Alphabetic: accept alphabetic characters only
@!	Upper Case
@^	Upper Case Alphabetic
@I#,#,#	Integer value with maxlength,minvalue,maxvalue: e.g. @I10,100,1000
@F#,#,#	Double value with maxlength,maxdecimals,minvalue,maxvalue: e.g. @F10,2,0,10000
?<regular expression>	Regular expression: prefix with '?' to indicate a regular expression. e.g. ?\\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,4}\\b
!A9X	VFP-style picture characters:

@9,3

That will restrict to 3 digits.

@9,3,5,200

That will restrict to 3 digits in the range 5 to 200