Inputfield properties

Following are the inputfield properties :

Property Description
Name The name of the input field. No special characters and spaces are allowed to be included as part of the name. A column with this name is created in the table in the database specified for the DC.
Caption This is the caption given to the input field. The Caption is displayed to the user in the Transaction Form.
DataType This is the data type for the input field value. Axpert allows five data types :
1. Character (Alphanumeric)
2. Numeric
3. Date/Time
4. Image
5. Text
On setting the datatype, the system allows only the specified data type value to be entered at run time.By default ,an input field is of Character data type.
DataWidth Enter the width of the field specific to the data type . On setting the DataWidth ,the data entry is restricted to the value specified.In the case of a Character, the minimum width of 1 can be defined and allows a maximum of 4000 characters.
Decimals Applicable only in the case of the Numeric Data type. On specifying this, the system allows a real number to be entered.  See also Dynamic decimals.
ModeOfEntry An MOE defines the manner in which data will be input or derived into the input field during run time.The MOE should be Accept if an input field should accept the data input by the user at runtime.If the value needs to be computed at runtime, then the MOE should be Calculate.The MOE should be set to AutoGenerate if the field value has to be automatically generated as a sequence.Use Select as the MOE to retrieve data from another structure or query.Use Fill to populate the input field based on a value above it.
Details Applicable when the MOE is Accept, Select, AutoGenerate or Fill. For each of these MOE, the details property needs to be set accordingly.
Hidden Set to True to hide the field in the form.
ReadOnly Set to True to disable field in the form and prevent modification of its data at run time.
SetCarry Set to True to carry the previous transaction’s field value to the next transaction.For instance,if you are entering many Vouchers for the same date, you can set this property as True for the Voucher Date field in a Voucher TStruct. On doing this, the date of the previous voucher in the Voucher Form will be defaulted in the new one entered. It is also possible to alter this carried forward data.
SaveValue When set to False, this field is not created in the database table and value in this field will not be saved to database.
Expression Use this property to perform calculations, evaluations or for prefixing values.
ValidateExpression Set another expression here to check if the value for the field is correct or not.
AllowDuplicate When set to False, prevent users from entering duplicates values in this field. The duplicate will be checked across all transactions entered in this Tstruct if the field is a non grid field. It will be prevent duplicate line items to be entered in one form if the field is a grid field.
AllowEmpty When set to False, prevents users from leaving the field empty.
OnlyPositive Allows only positive numbers to be entered in the field. This is applicable only for numeric fields.
ApplyComma Displays numeric values with commas in either millions or lakhs as per the setting in application properties.
Mask Mask dictates the format of values that could be entered in the field. Read more…
  • This property validates the format of values entered in the field.
  • Each set begins with an opening bracket ([) and ends with a closing bracket (]). Between the brackets are the elements of the set. Each element is a literal character or a range.
  • Ranges are specified by an initial value, a dash (-), and a final value. Do not use spaces or commas to separate the elements of the set. A set must match a single character in the string.
  • The character matches the set if it is the same as one of the literal characters in the set, or if it is in one of the ranges in the set. A character is in a range if it matches the initial value, the final value, or falls between the two values.
  • All comparisons are case-insensitive. If the first character after the opening bracket of a set is an exclamation point (!), then the set matches any character that is not in the set.Wildcards are asterisks (*) or question marks (?). An asterisk matches any number of characters. A question mark matches a single arbitrary character.
  • If the field is meant for entering Email, use the keyword isemail .
  • If the field is meant for entering numeric characters ( Mobile Number) use the keyword isnumeric


PasswordCharacter Specify a single character here. This character will be used
for display in case the entered text/value is being used as a Password or is being hidden for the sake of security.
ClientValidation Set this to True to do the validation at the component itself. If False, the validation will be done only when data is submitted.
SearchSQL Applicable if save value is false. If this field exists in another Tstruct,you can specify a query here to retrieve it for search.
DisplayDetail A string value can be entered in this field. At run time,when the user focuses on this field this string value will be displayed as a comment . The string can contain values entered in other fields. This is done by preceding the fieldname with colon in the string. For example, consider a product name field. On focus, if the comment should have some description of the product, then this property can be set as :ProductDesc. ProductDesc should be another hidden field in the grid DC that will have the description. You can also use hyperlink here to link to TStruct, IView or Page. Read More about hyperlink
TabStop This property is available only when ReadOnly property is set to true. When TabStop is set to False, the field will not receive focus when using tab keys to move from one field to another. When TabStop is set to True, Axpert lets users focus on a field but not change its value.