INPUTBOX is a versatile data entry component that can be configured to behave in a variety of modes depending on the setting of the Input Type: parameter. The set of parameters available to specify will vary depending on the value selected in the Input Type: parameter. INPUTBOX can be used in place of the following data entry objects:
Additionally, an INPUTBOX can provide two data types not found in other data entry objects:
Finally, INPUTBOX formats 'Currency', 'Percentage' and 'Number'-types according to either the US or EU conventions (see Regional differences in number formats, below).
|Label:||Text displayed to the left of box|
|Input Type:||Select the data type. (options listed below)|
|Default:||Default value to be displayed|
|Range Reference:||Select NAMED RANGE or existing RANGE REFERENCE to link value to cell in an Excel spreadsheet|
|Label Width:||Width in pixels of Label:|
|Label Style:||A reference to a USER INTERFACE STYLE that controls the visual appearance of INPUTBOX's label.|
|Input Style:||A literal string, a USER INTERFACE STYLE, or an object reference for dynamic CSS-style to apply to the input area|
|Show if:||Logical expression, if TRUE then box shown, if FALSE then box NOT shown|
|Enable if:||Logical expression, if TRUE then box enabled, if FALSE then box NOT enabled|
|Tool Tip:||Text to be displayed as a tool tip|
|Decimal Places:||The number of decimal places shown|
|Thousand Separator:||Select whether to show a thousands separator (default→FALSE, TRUE).
See Regional differences in number formats.
|Currency Symbol:||Select the currency symbol (default→$, £, €, ¥)|
|Pattern:||Select a format for storage and display of date and time|
|Tab Index:||Establish an order of preference for <TAB> key navigation. Highest priority is the lowest number (default→1) and continues in ascending numerical order. Use -1 to disable.|
|Characters:||Width of INPUTBOX in characters|
|Show Date Button:||When set to TRUE, a BUTTON will be displayed next to the object which allows selection from a calendar. Only available if Input Type:'DateTime'. (default→TRUE)|
|Number Format Code:||Select the custom number format to show.|
|Delimiter:||Character to act as delimiter in DORs on Label: and Default: above, when Input Type: is non-numeric. default→%.|
Child objects of INPUTBOX:
The Input Type: parameter is used to set the type of data entered into the INPUTBOX by the user. INPUTBOX has cell types compatible with Excel. Once Input Type: has been set for an INPUTBOX then other optional parameters will appear to allow further configuration. The available data types for the Input Type: parameter and their effects on the INPUTBOX are shown below.
The value of an INPUTBOX when Input Type: is set to ‘Percentage’ is actually the decimal value, the formatted or displayed value is the actual value multiplied by 100.
|Data Type||Effect||Optional Parameters|
|'Currency'||Sets the data entered to be a number that|
will be shown with the specified currency
symbol to the left of the number
|'Custom'||Set the data entered to be a custom format|
as specified by the selected format in the
Number Format Code: parameter
Number Format Code:
|'DateTime'||Sets the data entered to be a date and/or|
time stored and shown in the form
specified by the Pattern: parameter
|'General'||Allows any form of data to be entered||-|
|'Number'||Sets the data entered to be a number||Decimal Places:
|'Percentage'||Sets the data entered to be a number|
represented as a percentage with
% symbol shown after the number
|'Text'||Sets data entered will be treated as text,|
even if it is numerical
Input Type: allows Currency, Number or Percentage. The use of commas and periods to format thousands, millions, billions (the 'thousands separator') and decimal fractions less than one (the 'decimal mark') varies by region. EASA has implemented the two most common systems: US and EU.
In the US, commas are used as the 'thousands separator' and periods are used as the 'decimal mark'.
In the EU, periods are used as the 'thousands separator' and commas are used as the 'decimal mark'.
“Two million three hundred forty-three thousand two hundred thirty-two and thirty-four hundredths”
For a 'global' toggle between the two number formats for all an EASAP's 'Percentage', 'Currency' and 'Number'-type INPUTBOX's, set MENU ACTION's parameters below:
Thus INPUTBOX will accept input and display numbers in the locally expected convention.
For input 'thousands separator' is optional but 'decimal mark' must be the correct one, following a
Thousand Separator: parameter of INPUTBOX must be set to true to enable 'Number Formatting'.