The Field Properties dialog box enables you to set a data type of a field and a
Column Caption. These will be displayed in a feedback of a query that will use the field.
In the Data Type drop down list, you can set data type. The types are:
- Boolean. Boolean data field (yes/no, true/false, 1/0).
- Char. Data field that can contain one character.
- Date. Date field. The supported formats are: "dd MMMM,yyyy",
"dd-MMM-yyyy", "MM/dd/yyyy", "MMMM dd.yyyy"
- Double. Long (8 byte) floating point (8 byte) number field.
- Float. Floating point number field.
- Image. Text field that contains a URL of an image.
- Integer. Integer number field.
- Mail. Text field that contains an e-mail address.
- Time. Time format field
- URL. Text field that contains a URL.
- VarChar. Text field that can contain a string.
In the Column Caption, you can set a caption to be displayed in a feedback of a
corresponding query.