The Field Properties dialog box
enables you to set data type of field and Column Caption. These will be displayed in feedback of 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
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. It can contain a string.
In the Column Caption you can set caption that is to be displayed in feedback of a corresponding query.