ColMask property
      
 

Description

Returns/sets the mask string.

Syntax

object.ColMask (Col As Integer) As String

Remarks

The input mask can consist of the following characters.

Character Description
  0 Digit (0 through 9, entry required; plus [+] and minus [-] signs not allowed).
  9 Digit or space (entry optional; plus and minus signs not allowed).
  # Digit or space (entry optional; blank positions converted to spaces, plus and minus signs allowed).
  L Letter (A through Z, entry required).
  ? Letter (A through Z, entry optional).
  A Letter or digit (entry required).
  a Letter or digit (entry optional).
  & Any character or a space (entry required).
  C Any character or a space (entry optional).
  < Causes all characters that follow to be converted to lowercase.
  > Causes all characters that follow to be converted to uppercase.
  ! Causes the input mask to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask.
  \ Causes the character that follows to be displayed as a literal character. Used to display any of the characters listed in this table as literal characters (for example, \A is displayed as just A).