List Control Options

Go to:

Tools, Properties..., Display tab

The list control displays a list of values, either retrieved from the database or provided directly by you. Available list styles include dropdown lists, list boxes, and radio button lists.

List control options govern the number of records retrieved from the database for display in the list.

Options	Description
Create from database field or global permitted values list	Select this option to build the list from the values in the designated database field. If you have specified a list of permitted values (an enumerated list of values), then the permitted values will be used instead of the database field. If the field has a foreign key (real or virtual), then the list of values in the foreign table is used. If the field has no foreign key, then the table is scanned to construct the list of permitted values.
Maximum items to display	Specifies the maximum number of items to be fetched from the database. If the number of rows in the database exceeds Maximum Items, only Maximum Items will be retrieved. This limits the size of the dropdown list, limiting the database server load in certain cases.
Specify permitted values	Specifies the individual list items to be displayed. This option is available only if the list is not created from the database. When selecting this option, an extra “empty” item may be displayed in your application at run-time. For example, a radio button with no text may be displayed. This occurs when no default value has been specified for the field. To remove this empty item, click the Global Properties... button to specify one of the options as a default value.

List Control Options

See Also