Skip to content

FilterSeparatorStrict Property

Description

Specifies whether text filtering will be strict.

Property Type

Read-write property

Syntax (Visual Basic)

Public Property FilterSeparatorStrict() As Boolean

Remarks

FilterSeparatorStrict specifies whether text filtering will compare text in the FilterText property using the logical "AND" or the logical "OR" if the FilterText property contains strings separated by spaces.

The FilterText property is used to hold a string that is used to filter the rows in the Grid control. Only the rows that have RecordItems with a Caption that contains the text stored in FilterText will be displayed.

Placing a space between words in the filter string will cause the rows to be filtered by multiple strings. Each RecordItem in a Row will be searched for each word in the filter string individually. The filter string is not case sensitive, and the order in which the words appear in the filter string does not matter.

For example:

  • FilterSeparatorStrict = False: If the filter string was "Dog cat bird HORSE", only rows that contain any combination of the words "dog," "cat," "bird," and "horse" would be displayed. The order and case do not matter. In this case, "Bird Dog" will be a match, while "Bird Pig" would not, as "Pig" is not in the string.

  • FilterSeparatorStrict = True: If the filter string was "Dog cat bird HORSE", only rows that contain an EXACT combination of the words "dog," "cat," "bird," and "horse" would be displayed. The order and case DO matter. In this case, "Bird Dog" will NOT match as the order of the words does not match exactly, while "bird HORSE" would match as this combination of text matched exactly in both spelling and order.

The PopulatedRecordsCount property will return the total number of records currently in the grid after a filter string is applied.

See Also


Copyright (c) 1998-2024 Codejock Technologies. All rights reserved.