Input Masks

Under Construction

Input mask type

Available in Form Section and Canvas Section fields and Grid Section columns.

Using the named Input mask types requires a bound data source: a field from a table, or a memory variable (m.memvar) with a default expression to specify the width of the corresponding picture.

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: currency symbol followed by digits 0-9, comma for thousands and one decimal point. @C and @C2 indicate 2 decimal places; @C4 4 decimal places.
@D	Date: ISO date YYYY-MM-DD.
@E	Email: restricts input that would lead to an invalid email address such as multiple @, leading space, restricted symbols.
@F	Number: accepts +/- prefix followed by digits 0-9 and one decimal point.
@X	Text: accepts alphanumeric characters a-z, A-Z, digits 0-9 and printable symbols.
@T	Time: hh:mm:ss.
@A	Alphabetic: accepts alphabetic characters a-z, A-Z only.
@!	Upper Case: accepts alphanumeric characters a-z, A-Z, digits 0-9 and printable symbols. Lower case alphabetic characters are converted to upper case.
@^	Upper Case Alphabetic: accepts alphabetic characters a-z, A-Z only. Lower case alphabetic characters are converted to upper case.
@I#,#,#	Integer: integer value with maxlength,minvalue,maxvalue: e.g. @I10,100,1000.
@F#,#,#	Double: 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 (email address). Detailed information on regular expressions can be found here.
!A9X	VFP-style picture characters: each picture character corresponds to a character in the value, e.g. AAA, A99.  ! upper case A alphabetic 9 numeric X alphanumeric.