Input Masks
From Lianjapedia
Revision as of 13:16, 2 February 2015 by Yvonne.milne (Talk | contribs)
Under Construction
Input mask type
Available in Form Section and Canvas Section fields.
Using the named pictures 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: 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: each picture character corresponds to a character in the value, e.g. AAA, A99. |
@9,3
That will restrict to 3 digits.
@9,3,5,200
That will restrict to 3 digits in the range 5 to 200