Filters the column as user types characters in the drop down filter window.
Type
Description
Boolean
A Boolean expression that specifies whether the column gets filtered as the user
types characters in the drop down filter window.
By default, the FilterOnType property is False. The
Filter-On-Type feature allows you to filter the control's data based on the
typed characters. Use the DisplayFilterButton
property to add a drop down filter button to the column's header. The
Filter-On-Type feature works like follows: User clicks the column's drop down
filter button, so the drop down filter window is shown. Use starts type
characters, and the control filters the column based on the typed characters
as it includes all items that starts with typed characters, if the AutoSearch
property is exStartWith, or include in the filter list only the items that
contains the typed characters, if the AutoSearch property is exContains. Click
the X button on the filterbar, and so the control removes the filter, and so
all data is displayed. The control fires the FilterChange
event to notify whether the control applies a new filter to control's data.
Once, the FilterOnType property is set on True, the column's FilterType
property is changed to exPattern, and the the Filter
property indicates the typed string. Use the FilterCriteria
property to specify the expression being used to filter the control's data
when multiple columns are implied in the filter. Use the Description
property to customize the text being displayed in the drop down filter window.
Use the FilterHeight property to
specify the height of the control's filterbar that's displayed on the bottom
side of the control, once a filter is applied. The "Filter
For" (pattern) field in the drop down filter window is always shown if
the FilterOnType property is True, no matter of the DisplayFilterPattern
property.