Remove a filter

This topic explains how you can remove a filter to view all records in a view, and to permanently remove filters saved with an object or view.

For help with applying filters in Access, see the topic Filter: Limit the number of records in a view or report.

Remove a filter (filter: A set of criteria applied to data in order to display a subset of the data or to sort the data. In Access, you can use filtering techniques, such as Filter By Selection and Filter By Form, to filter data.) either to see all records or to apply a set of filters that are different from the currently applied filters. Note that you cannot remove just a portion of a filter. In other words, if you filter by City and then by Date, you cannot remove the filter only on the Date field or on the City field. To filter by only one field, you must remove the entire filter and then apply a new filter based on just that one field.

In Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.) or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.), click Remove Filter Button image on the Filter/Sort toolbar. If you are working on a shared database, click Remove Filter/Sort on the Records menu to remove filters and then immediately update your view. Note that removing a filter from a datasheet (datasheet: Data from a table, form, query, view, or stored procedure that is displayed in a row-and-column format.) also removes filters from the subdatasheet (subdatasheet: A datasheet that is nested within another datasheet and that contains data related or joined to the first datasheet.).

In a report (report: An Access database object that you can print, which contains information that is formatted and organized according to your specifications. Examples of reports are sales summaries, phone lists, and mailing labels.), in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.), set the FilterOn property of the report to No.

In Page view, click Filter Toggle Button image on the record navigation toolbar so that it is not selected.

To remove filters that were applied programmatically, review the code that is attached to the OnOpen event of a form or report.

If, after all these steps, you still don't see the records that you are looking for, review the record source (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.) that the view or report is bound to. In the case of a shared database, find out if other users made changes that are affecting your view or report.

Delete a filter (permanently delete current or saved filters)

In Datasheet view or Form view, on the Records menu, point to Filter, and then click Advanced Filter/Sort. To delete all filters, on the Edit menu, click Clear Grid. To delete specific criteria, clear the corresponding cells. Then click Apply Filter on the toolbar.

In a report, delete the value of the report's Filter property, and set the FilterOn property of the report to No.

Applies to:
Access 2003