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 the file and disk sizes. Remark: The change of unit (from KB to MB for example) 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 selected 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 %
• Using brackets: displaying the negative numbers.
  Example:
  
  EDT_Edit1.DisplayMask = "(999 999)"
  EDT_Edit1 = -1234      // Displays (1 234)
  EDT_Edit1 = 1234       // Displays 1 234
  
• Using the - sign at the end of the string: displaying negative numbers (ability to write "--" to display the - sign at the end of string)
  Example:
  
  EDT_Edit1.DisplayMask = "999 999 -"
  EDT_Edit1 = -1234      // Displays 1 234-
  
• Multiple display mask: display mask used to define the format of positive numbers, the format of negative numbers, the value if 0 is used, the 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
  
  
  Remark: You can specify a color using [<Color>] next to the desired mask. <Color> can correspond 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
  
  
  Remark: 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".
  However, the number "12,368" is displayed properly: 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, ... 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, ... The result is expressed in universal time (UTC). Not available.
  maskDateInternet	The format used corresponds to the RFC-3339 standard used for international communications. The result is expressed in the local time zone.
  maskDateInternetUTC	The format used corresponds to 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 expressions in the current language can be configured in the project description: 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 the 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 will be displayed (the number of hours in our example).
• +2: only the two most significant units will be displayed (the number of hours and the number of minutes in our example).
  Specify '+3' or '+4' to display the three or four most significant units.
• D: the number of days will be displayed if this number is greater than 0 (the number of days will not be displayed in our example).
• H: the number of hours will be displayed if this number (or if 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 if 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 days, or the number of 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 days, or the number of 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 if the number of days, or the number of hours, or the number of 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 if the number of days, or the number of hours, or the number of 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 second will be displayed (the number of hundredths of second will be '41' in our example).
• CCC: the number of thousandths of second will be displayed (the number of thousandths of second will be '412' in our example).

• 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), you must define a mask such as: "+5 HHhMMm", where "+5" indicates the number of digits to display 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 the DisplayMask property: 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.