Masks
Previous Topic  Next Topic 

Order Numbers, Part Numbers, and Job Identifications can have input masks.   That is, you can set the input format you want these fields to have and the user must follow the input format.  Masks for the above fields are setup in Terms and Settings.


The following are special characters that can be used in a text mask:


Character                                    Meaning in mask        


!        If a ! character appears in the mask, optional characters are represented in the returned

       string as leading blanks. If a ! character is not present, optional characters are represented

       in the returned string as trailing blanks.        


>        If a > character appears in the mask, all characters that follow are in uppercase until the

       end of the mask or until a < character is encountered.        


<        If a < character appears in the mask, all characters that follow are in lowercase until the end

       of the mask or until a > character is encountered.        


<>        If these two characters appear together in a mask, no case checking is done and the data is

       formatted with the case present in the Value parameter.        


\        The character that follows a \ character is a literal character. Use this character to use any

       of the mask special characters as a literal.        


L        The L character requires an alphabetic character only in this position (A-Z, a-z).        


l        The l character permits only an alphabetic character in this position, but doesn't require it.        


A        The A character requires an alphanumeric character only in this position (A-Z, a-z, 0-9).        


a        The a character permits an alphanumeric character in this position, but doesn't require it.        


C        The C character requires an arbitrary character in this position.        


c        The c character permits an arbitrary character in this position, but doesn't require it.        


0        The 0 character requires a numeric character only in this position.        


9        The 9 character permits a numeric character in this position, but doesn't require it.        


#        The # character permits a numeric character or a plus or minus sign in this position, but

       doesn't require it.        


:        The : character is used to separate hours, minutes, and seconds in times. If the character

       that separates hours, minutes, and seconds is different in the regional settings of the

       Control Panel, that character is substituted in the returned string.        


/        The / character is used to separate months, days, and years in dates. If the character that

       separates months, days, and years is different in the regional settings of the Control Panel,

       that character is substituted in the returned string.        


_        The _ character automatically inserts spaces into the returned string.        


Any character that does not appear in the preceding table can appear in the mask as a literal character.

The special mask characters can also appear as literal characters if preceded by a backslash

character (\).