Format types for controls

The format type defines the kind of values a user can enter into an edit box, search range, or label control type, such as a decimal value or a date. When you select a format type, Infor Public Sector may show additional properties that you must set. The format type you specify for a control must be compatible with the data type of the property that will be bound to the control. For example, if an edit box is bound to a date/time property, it should have a DateAndTime, Date, or Time format type. This table describes each format type available for controls in Infor Public Sector.
Format type Description
General No specific format. The control can accept any input.
Decimal Numeric value with a decimal point. You can set the number of decimal places using the Decimal Places property.
Integer Whole number.
Currency Numeric value for money. You can set the number of decimal places using the Decimal Places property.
Date Date.
Date and Time Date and time.
Time Time.
Phone Phone number, including area code.
Mask Personalized format type. Selecting Mask shows the Mask Format property, which you can use to define your mask. You can use the pound sign (#) to indicate that a character must be a number, and use the asterisk (*) to indicate that any character can be used.

For example, you might want to add a mask for parcel codes that specifies this pattern: Letter Number - Number Number. For this pattern you would specify this mask format: *#-##

AlphaNum Any combination of letters and whole numbers.