Delete or remove a filter (MDB)

Microsoft Office Access 2003

previous page next page

ShowDelete a filter in a form or datasheet

Use this procedure to delete any type of filter, regardless of what method you used to create it.

  1. Click in the form, subform, datasheet, or subdatasheet whose filter you want to delete.
  2. Switch to the Advanced Filter/Sort window.
  3. On the Edit menu, click Clear Grid.
  4. Click Apply Filter Button image on the toolbar.

ShowDelete an inherited filter in a report

  1. Open the report in Design view, or if the report is already open, make sure it is selected.
  2. Click Properties Button image on the toolbar to display the report's property sheet.
  3. In the Filter property box, delete the SQL WHERE clause.
  4. Set the FilterOn property to No.

ShowRemove a filter

ShowRemove a filter to show all records in a form or datasheet

Do one of the following:

  • To remove a filter and show the records that were displayed previously in the table, query, or form, click Remove Filter Button image on the toolbar in Form view or Datasheet view.
  • To remove a filter in a multiuser (shared) database and see which records have been added, deleted, or changed since you opened the table, query, or form, click Remove Filter/Sort on the Records menu in Form view or Datasheet view.

Note  Removing a filter doesn't delete it. You can reapply the filter by clicking Apply Filter Button image on the toolbar. When you remove a filter from a datasheet, Microsoft Access also removes any filters you applied to any subdatasheet within it.

ShowRemove an inherited filter in a report

  1. Open the report in Design view, or if the report is already open, make sure it is selected.
  2. Click Properties Button image on the toolbar to display the report's property sheet.
  3. In the FilterOn property box, click No to remove the filter.

ShowRemove a filter to show all records in a data access page in Page view

  1. Open a data access page in Page view.
  2. Click Filter Toggle Button image on the record navigation toolbar so that it is not selected.

Notes

  • Removing a filter doesn't delete it. You can reapply a filter during the current working session by clicking the Filter Toggle button on the record navigation toolbar so that it is selected.
  • This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. These features can be filtered independently from the rest of the data on the data access page, and may also support additional filtering capabilities. For more information, click Help Button image on that component's toolbar.

ShowRemove a filter data in a PivotTable or PivotChart view

ShowRemove a filter from a PivotTable

When items in a field are hidden by filtering a field or filtering by selection, the arrow Field arrow in the field label is blue. When items are hidden by filtering for top or bottom values, the filtered field displays a funnel icon Button image to the left of the arrow.

  1. Open a datasheet or form in PivotTable view.
  2. Do one or more of the following:

ShowRemove all filters

  • Click the AutoFilter button Button image on the PivotTable toolbar so that it is not selected.

Note  If you click AutoFilter Button image again to turn filtering back on, the previously set filters will be reapplied.

ShowRemove an autofilter, or a filter by selection, from a field

  • Click the blue arrow Blue arrow of the field from which you want to remove the filter.

  • Select the (All) check box and click OK.

ShowRemove a conditional filter from a field

  • Select the field from which you want to remove conditional filtering.

  • On the PivotTable toolbar, click Show Top/Bottom Items Button image, and then click Show All.

Note  If you don't want to retain your filters, make sure the AutoFilter button Button image is not selected before you start selecting items to filter. If the button is not selected, selecting new items to filter automatically turns filtering on and removes your former filter settings.

ShowRemove a filter from a PivotChart view

When items in a field are hidden by filtering a field or filtering by selection, the arrow Field arrow in the field label is blue.

  1. Open a datasheet or form in PivotChart view.
  2. Do one of the following:

    ShowRemove all filters

    • Click the AutoFilter button Button image on the PivotChart toolbar so that it is not selected.

    Note  If you click AutoFilter Button image again to turn filtering back on, the previously set filters will be reapplied.

    ShowRemove an autofilter from a field

    1. Click the blue arrow Blue arrow of the field from which you want to remove the filter.
    2. Select the (All) check box and click OK.

    ShowRemove a conditional filter from a field

    1. Select the field from which you want to remove conditional filtering.
    2. On the PivotChart toolbar, click Show Top/Bottom Items Button image, and then click Show All.

Note  If you don't want to retain your filters, make sure the AutoFilter button Button image is not selected before you start selecting items to filter. If the button is not selected, selecting new items to filter automatically turns filtering on and removes your former filter settings.

previous page start next page