- Numeric controls (except for the currency controls)
- Currency controls
- Currency + Euro controls
- Date controls
- Time controls
- DateTime controls
- Duration controls
- Text controls in the report editor
- Type of input mask
- Regular expressions in the input masks
- Limitations
The InputMask property is used to: - get the input mask.
- set the input mask (from the masks available for the type).
The InputMask property applies to all controls that allow input or display text: - an Edit control.
- a group of Edit controls.
- an editable Combo Box control.
- a column in a Table control,
- a cell in a Table control,
- a progress bar,
- a formatted static control.
The InputMask property also applies to Calculated and Static Text controls in reports. Remark: The input mask of a control is defined in the window or report editor, in the "General" tab of the control description..
For more details on the different input masks available and their characteristics, see Input mask.
SAI_NomClient.MasqueSaisie = maskUpper
TABLE_Table1.COL_Prix[1].MasqueSaisie = "9999,99"
Info(TABLE_Table1.COL_Prix[1].ValeurAffichée)
Sintaxis <Result>: Constant or character string Input mask of the specified control. The input mask depends on the type of control. For more details, see remarks. <Control used>: Control name Name of the control to be used.
Changing the input mask of a control Ocultar los detalles
<Control used>.InputMask = <New input mask>
<Control used>: Control name Name of the control to be used. <New input mask>: Constant, character string or InputMask variable New input mask for the specified control. This mask can correspond to: - A string or constant, specifying the mask to use.
The input mask depends on the type of control. For more details, see remarks.
Observaciones Numeric controls (except for the currency controls) 1. Preset input masks | | | maskBitcoin | Numeric input mask used for Bitcoins. The Bitcoin symbol is displayed. | | 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. | | maskSystemNumeral | Numeric mask used by the system.
Corresponds to the mask defined in the system regional settings ("Regional options" in the control panel). |
Examples:
SAI_Saisie1.MasqueSaisie = maskFileSize
SAI_Saisie1 = 5681234
SAI_Saisie2.MasqueSaisie = maskBitcoin
SAI_Saisie2 = 5681234
SAI_Saisie3.MasqueSaisie = maskScientific
SAI_Saisie3 = 5681234
2. Custom input masks Input masks are defined using the following characters: "9", ".", ",", "+" and "-", "$" and spaces.. For example: "99.999,99". In display mode, the decimal and thousand separators as well as the symbol defined for the language are taken into account. In the code (regardless of the language): - " " (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).
3. Specific custom input masks - Using the % symbol:
Caution: Until version 90028, the value assigned to the field by programming was displayed as is, followed by the % character..
From version 90033, the valued assigned to the control through programming is multiplied by 100 and the "%" character is displayed. To restore the operating mode of the earlier versions, write "%%" to display the % character without multiplying the value by 100.
Example: - Assigning a value to the control programmatically:
SAI_Saisie1.MasqueSaisie = "999,9%"
SAI_Saisie1 = 0.562
SAI_Saisie1.MasqueSaisie = "999,9%%"
SAI_Saisie1 = 0.562
- Input in the control by the user:
- Mask 99.99%, value entered: 19.6, value displayed: 19.6%, value manipulated by programming: 0.196.
- Mask 99.99%%, value entered: 19.6, value displayed: 19.6%, value manipulated by programming: 19.6.
- Use of parentheses: display of negative numbers.
Example:
SAI_Saisie1.MasqueSaisie = "(999 999)"
SAI_Saisie1 = -1234
SAI_Saisie1 = 1234
- 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:
SAI_Saisie1.MasqueSaisie = "999 999 -"
SAI_Saisie1 = -1234
- Multiple input mask: input mask for defining the format of positives, the format of negatives, the value if 0 is used, the value if NULL is used.. The following syntax is used:
<Format des positifs>;<Format des négatifs>;<Valeur si 0>;<Valeur si NULL>
Example:
SAI_Saisie1.MasqueSaisie = "999 999;-999 999;0;<NULL>"
SAI_Saisie1 = -1234
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:
SAI_Saisie1.MasqueSaisie = "999 999;-999 999[Rouge];0;<NULL>"
SAI_Saisie1 = -1234
SAI_Saisie1.MasqueSaisie = "999 999;-999 999[ #FF0000];0;<NULL>"
SAI_Saisie1 = -1234
Note: The color specified in the input mask takes precedence over the Color property.. It is ignored if the control is grayed.
Remarks: - Using 0 in the input mask:
- If you want to pad the number with zeros on the left, use "0" on the left of the mask. For example:
SAI_Saisie1.MasqueSaisie = "099.999,99"
SAI_Saisie1 = 23,50
- 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:
SAI_Saisie1.MasqueSaisie = "9999,000"
SAI_Saisie1 = 12
SAI_Saisie1 = 12,368
- To force the signs, use the "+" character on the left. For example: "+9999"..
Currency controls The input masks have the same type as the numeric masks. The difference lies in precision: the monetary units have 17 significant digits for the integer part and a maximum of 6 decimal places. For example: "99 999 999 999 999,999999". Note: A predefined mask can also be used for Monetary type fields:
| | | maskSystemCurrency | Currency mask used by the system. Corresponds to the mask defined in the system regional settings ("Regional options" in the control panel). |
Currency + Euro controls The input masks have the same type as the currency masks. The dollar character ("$") can be added into the mask to display the current currency. For example: "$999.99" will display "250.25 F" if the current currency is the franc. Date controls The input masks for Date controls are: - "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"
- DD (corresponding to the day of the week in figures, e.g. 12)
- "DDDD" (corresponding day of the week, e.g. "Thursday"). The case used depends on the language options of the project.
- "DDDD" (corresponding to the day of the week with the first letter capitalized, e.g. Monday)
- "dddd" (corresponding to the day of the week with the first letter forced into lower case, e.g. Monday)
- "DDD" (abbreviation for the day of the week, "Thu" for example). The case used depends on the language options of the project.
- "DDD" (abbreviation for the day of the week with the first letter capitalized, e.g.: Mon)
- "ddd" (abbreviation for the day of the week with the first letter forced into lower case, e.g.: mon)
- MM (month in figures, e.g. 12)
- "MMMM" (non-abbreviated month, for example "January"). The case used depends on the language options of the project.
- "Mmmm" (month spelled out with the first letter capitalized, e.g. January)
- "mmmm" (month in all letters with the first letter forced into lower case, e.g. January)
- "MMM" (abbreviation of the month, "Jan" for example). The case used depends on the language options of the project.
- "Mmm" (month abbreviation with the first letter capitalized, e.g. Jan)
- "mmm" (month abbreviation with the first letter forced into lower case, e.g. jan)
- "YYYY" (year on four digits, "2001" for example)
- "YY" (last two digits of the year, "01" for example)
- the date defined by the project.
The date defined by the project depends on the date format selected in the parameters of the project language: - on the "Proyecto" tab, in the "Proyecto" group, click "Descripción".
- display the "Languages" tab then the language options regarding the date.
These masks can be combined. For example: "On DD DD Mmmm YYYY at HH:mm" will give a result of the form "On Thu Feb 01 1979 at 21:35". Time controls The input masks for the time controls are: - "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 To specify a DateTime input mask, you must: - Switch the type of the control (or table column) to Date ("Details" tab in the description window of the control or column).
- Change the input mask of this control or column ("Details" tab in the control or column description window, or InputMask property).
Duration controls The following elements can be used to define a custom mask (case sensitive). To present the custom masks, let's take a duration equal to 0 day 04 hours 15 minutes 03 seconds and 412 thousandths of a second: - +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').
Note: If the separator corresponds to the ":" character, the letter corresponding to the most significant unit will be added (letter 'h' for hour, 'm' for minute, 's' for second, 'cs' for hundredths of a second and 'ms' for thousandths of a second). Type of input mask Caution: Changing a mask can only be done with an mask of the same type.. For example, the input mask of a DATE control cannot be replaced with the input mask of a TIME control. Assigning an incorrect input mask will trigger an error message.
Esta página también está disponible para…
|
|
|