Symptoms
In Microsoft Office Access 2007, filter criteria on multivalued fields do not show the filter applied. For example, when you click a filter in the sorting and filtering group on the Main tab, the filter condition is not displayed. When you click the datasheet header, the filter icon in the Apply filter criteria does not appear or. Instead, there is no filter condition that seems to have been set. Even if you can see the word filtered record navigation bar and status bar on the.
Reason
This problem occurs if the following conditions are true:
• |
Data is filtered, contains columns, and is filtered for multiple values in the record. |
• |
The filter has been applied to the data. |
Alternative methods
To resolve this issue, use one of the following methods. Method 1: View applies a filter to view the Apply filter criteria, use one of the following procedures:
• |
The mouse pointer rests on the column headings in the datasheet. Prompt displays the current filter condition. |
• |
In the sort and filter groups, in the Main tab click Advanced, and then click Advanced Filter/Sort. |
Method 2: Change apply filter criteria to apply filter criteria, use one of the following procedures:
• |
Click the Main tab to filter or filter icons in the datasheet header in the sorting and filtering group. Then, perform the following steps:
1. |
Click to clear the Select all check boxes. |
2. |
Click to select the check box based on each filter condition. |
3. |
Click OK. |
|
• |
On the main tab, sort and filter groups, click Advanced, and then click Advanced Filter/Sort. For the criteria field, make the changes you want, and then click Close. |
State
Microsoft has confirmed that this is a problem in the "Applies to" section that lists the Microsoft products.
More information
Multivalued fields, where you see conditions in the filter window that may not accurately display the application filter criteria. This problem may occur in tables and queries for forms, reports, and Recordset objects that may occur for the Filter property. However, the existing filters are still applied correctly.
For information about how to use advanced filtering, click Microsoftofficeaccess Help, or press F 1. In the search box, type a filter record, and then click Search to see the topic returned.
For multivalued fields, click Microsoftofficeaccess Help, or press F 1. In the search box, type the Guide to multivalued field, and then click Search to see the returned topic.