Index.
You can use the IgnoreNulls property to specify that records with Null values in the indexed fields are not included in the index.
The IgnoreNulls property uses the following settings.
|
Setting |
Description |
Visual Basic |
|
Yes |
Records that contain Null values in the indexed fields aren’t included in the index. |
True (-1) |
|
No |
Records that contain Null values in the indexed fields are included in the index. |
False (0) |
You can set this property in the Indexes window of table Design view or in Visual Basic.
Note To access the IgnoreNulls property of an index using Visual Basic, use the Data Access Object’s IgnoreNulls property.
You can define an index for a field to facilitate fast searches for records using that field. If you allow Null entries in the indexed field and expect to have many of them, set the IgnoreNulls property for the index to Yes to reduce the amount of storage space that the index uses.
IgnoreNulls Property (Microsoft Office 95 Data Access Reference), Indexed Property, Primary Property, Unique Property.