Edit Filter Control

The Edit Filter Control dialog box is used to edit a filter control. It appears when you right-click on a filter control and then select Edit, or when you select Select Fields beside the Filter On text box on the the General tab of the Filter Control Properties dialog box.

Edit Filter Control dialog

Control Type

Specifies the type of the filter control.

Select Fields

Specifies the fields to bind to the filter control. All the selected fields should be of the same data type. The incomparable data type fields cannot be bound to a single filter control, such as Binary, Blob, Clob, Longvarchar, Longvarbinary, and Varbinary.

Customize Initial Values

Specifies to customize the value list of the filter control.

Fetch Data
Opens the Fetch Data dialog box to select values from the database and adds the selected values to the text box below.
Text box
You can type values directly in the text box. Make sure the accuracy of their formats and values.
The text box is an editable multi-row plain text box. It supports general text editing operations including copy, paste, cut, backspace, delete and etc. The Enter key on the keyboard is used to start a new row. Each row is a value of the user defined value list.
When Customize Initial Values is selected but the text box is empty, all values of the selected fields will be used in the filter control.
Specifies a Date/Time value in the text box.