Alternate Filtering

Format of Filtering Row when Alternate Filtering is in use:

Applying an Alternate Style Filter

To apply filter using the alternate filtering facility, first activate it for the list by unchecking the Multi-Select Filter Style checkbox in the Grid Options group of the View tab, or right-clicking on the list and un-ticking the Multi Select Filter option on the menu that is then displayed.

Select a filter criterion, for example, Starts with, Contains or Does not end with from the drop-down list displayed by clicking the left-hand button in the filtering row of the column.

If a value is selected without a criterion being selected, the Contains criterion is applied by default.

Then either enter a value in the field to the right of the criterion selection button, or click on the button to the right of this field and select a value from the list that is then displayed.

The list contains every value in the column, plus Blanks and NonBlanks.

If Blanks is selected rows without a value in the column are displayed when the filter is applied. If NonBlanks is selected rows with a value in the column are displayed.

The selected value is displayed in the field between the two buttons.

The filter is then applied to the list.