Type

Purpose

Bitmap Image

External bitmaps (only the filename is stored in the database, the data itself is kept in an external file).

Check Box

Presents a check box that can be checked or cleared. Useful for booleans. Read "Guidelines for Presenting Allowed Values" for more information.

Dropdown List Box

Presents a dropdown list of allowed values. Useful for data with not too many values.

Multi-line Text Box

Allows long texts to be entered (the exact length is determined by your RDBMS).

OLE Container

Creates a large field in which OLE objects are inserted via the right mouse menu. Developers can also insert OCXs using the Windows Designer.

Option Buttons

Presents a group of (radio) buttons, one for each allowed value. Only one value can be chosen. Useful for data with only a few values, and where a quick view of the allowed values is necessary.

Slider

Presents a scale (continuum) of values, with a "thumb" or "slider" that can be moved like a scroll bar.

Text Box (Alpha)

A-Z

Text Box (Character)

All 256 ASCII characters (by default: AAAA, with the number of A's depending on the column width).

Text Box (Date)

Dates in the format MM-DD-YY. (If you use this data type, do NOT specify the column width.)

Text Box (Date and Time)

Date and time (by default: DD-MON-YY HH24:MI:SS)

Text Box (European Date)

Dates in the format DD-MM-YY. (If you use this data type, do NOT specify the column width.)

Text Box (Integer)

Whole numbers (integers) only. (If you use this data type, do NOT specify the column width.)

Text Box (Julian Date)

Dates in the format DD-MON_YY). (If you use this data type, do NOT specify the column width.)

Text Box (Money)

Amounts of money (by default: [-]ZZZZZ9[.99] ).

Text Box (Number)

Numeric characters (0-9), plus (+) and minus (-), exponent indicators (E, e). Default: [-]ZZZZZ9[.ZZZ].

The number of Z's before the decimal separator depends on the data length. The number of Z's after the decimal separator depends on the number of decimal places allowed.

Text Box (R Integer)

Displays a right-adjusted version of the Text Box (Integer) display type.

Text Box (R Money)

Displays a right-adjusted version of the Text Box (Money) display type.

Text Box (R Number)

Displays a right-adjusted version of the Text Box (Number) display type.

Text Box (Time)

Time (by default: HH24:MI:SS).

Text Document

External texts (only the filename is stored in the database, the data is in an external file). The Edit button starts WordPad with the referenced file.

Text Editor

Creates a field with an Edit button that opens the popup Text Editor.