Numeric controls (except for the currency controls)

1. Preset display masks
2. Custom display masks
3. Special custom display masks

maskBitcoin	Numeric input mask used for Bitcoins. The Bitcoin symbol is displayed. This constant is not available.
maskFileSize	Numeric mask for file and disk sizes. Note: The unit change (e.g. from KB to MB) is performed for each multiple of 1024.. Therefore, the mask may display 1003 KB.
maskScientific	Numeric input mask for scientific notation. This constant is not available.
maskSystemNumeral	Numeric mask used by the system. Corresponds to the mask defined in the system regional settings ("Regional options" in the control panel).

• " " (space) is replaced with the thousand separator
• "," (comma) is replaced with the decimal separator
• "$" is replaced with the currency symbol (write "$$" to avoid this substitution)

• Using the % symbol:
  The value assigned through programming to the control is multiplied by 100 and the "%" symbol is displayed.
  You can write "%%" to display the % character without multiplying the value by 100.
  Example: Assigning a value to the control programmatically
  
  EDT_Edit1.DisplayMask = "999,9%"
  EDT_Edit1 = 0.562 // Displays 56.2 %
   
  EDT_Edit1.DisplayMask = "999,9%%"
  EDT_Edit1 = 0.562 // Displays 0,6 %
• Use of parentheses: display of negative numbers.
  Example:
  
  EDT_Edit1.DisplayMask = "(999 999)"
  EDT_Edit1 = -1234      // Displays (1 234)
  EDT_Edit1 = 1234       // Displays 1 234
  
• Use of the - sign at the end of the string: display of negative numbers (it is possible to write "--" to display the - sign at the end of the string)
  Example:
  
  EDT_Edit1.DisplayMask = "999 999 -"
  EDT_Edit1 = -1234      // Displays 1 234-
  
• Multiple display mask: display mask to define positive format, negative format, value if 0 is used, value if NULL is used.. The following syntax is used:
  <Format of positive numbers>;<Format of negative numbers>;<Value if 0>;<Value if NULL>
  Example:
  
  EDT_Edit1.DisplayMask = "999 999;-999 999;0;<NULL>"
  EDT_Edit1 = -1234      // Displays - 1 234
  
  
  Note: You can specify a color by using [<Couleur>] next to the desired mask.. <Color> can correspond to:
  • to one of the following constants: Red, Green, Blue, Black, White, Yellow, Orange
  • a hexadecimal value in "#BBGGRR" format.
  Example:
  
  EDT_Edit1.DisplayMask = "999 999;-999 999[Red];0;<NULL>"
  EDT_Edit1 = -1234      // Displays - 1 234 in red
   
  EDT_Edit1.DisplayMask = "999 999;-999 999[#FF0000];0;<NULL>"
  EDT_Edit1 = -1234      // Displays - 1 234 in blue
  
  
  Note: The color specified in the display mask takes precedence over the Color property.. It is ignored if the control is grayed.

• If you want to pad the number with zeros on the left, use "0" on the left of the mask. For example: "099.999.99".
• If you want to pad the decimal part of the number to with zeros, use "9" to the right of the decimal point. For example, when using the "9999,99000" mask, the number 12 is displayed as "12,00" and not as "12,00000".
  On the other hand, the number "12.368" is correctly displayed: its value is preserved, without being truncated or rounded.
• To force the signs, use the "+" character on the left. For example: "+9999".

Currency controls

Currency + Euro controls

Date controls

• a custom mask:
  • "DD/MM/YYYY"
  • "DD/MM/YY"
  • "DDD DD"
  • "MM/DD/YYYY"
  • "MM/DD/YY"
  • "YYYY/MM/DD"
  • "YY/MM/DD"
  • "DD/MM/YYYY HH:MM:SS"
  • "MM/DD/YYYY HH:mm:SS"
  • "DD/MM/YYYY HH:mm:SS:CCC"
  • "MM/DD/YYYY HH:mm:SS:CCC"
  • "DDDD DD MMMM YYYY"
  • "Dddd DD Mmmm YYYY"
  • "Dddd DD Mmm YYYY"

• a constant corresponding to a preset mask:
  

  maskDateEmail	The format used corresponds to the date format of the RFC-5322 standard used to encrypt an email, an RSS feed, etc, ... The result is expressed in the local time zone. Not available.
  maskDateEmailUTC	The format used corresponds to the date format of the RFC-5322 standard used to encrypt an email, an RSS feed, etc, ... The result is expressed in universal time (UTC). Not available.
  maskDateInternet	The format used corresponds to the date format of the RFC-3339 standard used for international communications. The result is expressed in the local time zone.
  maskDateInternetUTC	The format used corresponds to the date format of the RFC-3339 standard used for international communications. The result is expressed in universal time (UTC).
  maskDateRelativeDuration	Mask used to express the time elapsed (or that will elapse) between today's date and the specified date. This mask is expressed in natural language. The different formulations used can be configured in the project description for the current language: On the "Project" tab, in the "Project" group, click "Description". In the "Languages" tab: select the language to configure. select the "Date" tab. Click the "Dates and Times in natural language" button. Define (if necessary) the custom captions to use. These captions will be used: for the result of DateToString. for the controls that use the "Relative duration" display mask.
  maskDateSystem	System mask defined in the project description for the current language: On the "Project" tab, in the "Project" group, click "Description". Select the "Languages" tab then the "Date" tab. The format used corresponds to: the settings of the operating system, the specified parameters (with the defined days and months).

Time controls

• "HH:MM"
• "HH h MM"
• "HH:MM:SS"
• "HH:MM:SS AM": Used to manage time in AM/PM format.
• "HH:MM:SS:CC"
• The preset mask corresponds to the system time. The system time depends on the mask selected in the regional system setings ("Regional options" in the control panel).
  

  maskSystemTime	Mask used by the system for the time.

DateTime controls

1. Change the type of the control (or table column) to Date ("Details" tab in the description window of the control or column).
2. Change the display mask of this control or column ("Details" tab in the control or column description window, or DisplayMask property).

Duration controls

• +1: only the most significant unit is displayed (in our example, only the number of hours).
• +2: only the two most significant units will be displayed (in our example, only the number of hours and the number of minutes)..
  Specify '+3' or '+4' to display the three or four most significant units.
• J: the number of days will be displayed if this number is greater than 0 (in our example, the number of days will not be displayed).
• H: the number of hours will be displayed if this number or the number of days is greater than 0.. If this number contains a single digit, this digit will be displayed (the number of hours will be '4' in our example).
• HH: the number of hours will be displayed if this number or the number of days is greater than 0.. If this number contains a single digit, this digit will be preceded by '0' (the number of hours will be '04' in our example).
• M: the number of minutes will be displayed if this number or the number of a longer duration (number of days or hours) is greater than 0.. If this number contains a single digit, this digit will be displayed (the number of minutes will be '15' in our example).
• MM: the number of minutes will be displayed if this number or the number of a longer duration (number of days or hours) is greater than 0.. If this number contains a single digit, this digit will be preceded by '0' (the number of minutes will be '15' in our example).
• S: the number of seconds will be displayed if this number or a longer number (days, hours or minutes) is greater than 0.. If this number contains a single digit, this digit will be displayed (the number of seconds will be '3' in our example).
• SS: the number of seconds will be displayed if this number or a longer number (days, hours or minutes) is greater than 0.. If this number contains a single digit, this digit will be preceded by '0' (the number of seconds will be '03' in our example).
• CC: the number of hundredths of a second will be displayed (in our example, the number of hundredths of a second will be '41').
• CCC: the number of thousandths of a second will be displayed (in our example, the number of thousandths of a second will be '412').

• If the separator corresponds to the ":" character, the letter corresponding to the most significant unit will be added ('h' for hour, 'm' for minute, 's' for second, 'cs' for hundredths of a second and 'ms' for thousands of a second).
• To display a duration in an Edit control in hours/minutes format (instead of days/hours/minutes), it is necessary to define a mask of the type: "+5 HHhMMm", where "+5" designates the number of digits to be displayed for the hours..

Type of display mask

Regular expressions in the display masks

• with the MatchRegularExpression function: the regular expression used is [A-Za-z][0-9]
• with property DisplayMask: the regular expression used is [A-Za-z]{0,1}[0-9]{0,1}

Limitations

• Numeric, Currency, Date, Time and Duration edit controls,
• Numeric, Currency, Date, Time and Duration columns of a Table control,
• groups of edit controls,
• editable or non-editable Combo Box controls.
• columns of a Table control displayed by Combo Box controls.