Show All

Enable or disable filtering records in a form (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

• Set the form's AllowFilters property to Yes to enable filtering or to No to disable filtering capabilities in Form view and in form Datasheet view.

  How?

  1. Open a table, query, form, report, or data access page in Design view.
  2. Open the property sheet by doing one of the following:
     • On a form or report, double-click the form selector or the report selector.

     

     Form or report selector

     • On a data access page, click Select Page on the Edit menu.
     • On a table or query, click Properties on the toolbar.
     • For a section on a form or report, double-click the section selector.

     

     Section selector

     • For a section on a data access page, double-click the section bar.

     

     Section bar

     • To set properties of a query field, click the cell in the Field row, and then click Properties on the toolbar.
     • To set properties of a query field list, click anywhere in the list, and then click Properties on the toolbar.
     • To set properties for the body of a data access page, click above the first section, and then click Properties on the toolbar.
     • To set properties for a control, click the control, and then click Properties on the toolbar.
  3. In the property sheet, click the property you want to set, and then do one of the following:
     • If an arrow appears in the property box, click it and then select a value from the list.
     • Type a setting or expression in the property box.
     • If a Build button appears next to the property box, click it to display a builder or list of builders.

  Tips

  • To get Help on any property in the property sheet, click the property and then press F1.

  • If you need more space to enter or edit a property setting, press SHIFT+F2 to open the Zoom box.

  Note  If the AllowDesignChanges property of a form is set to All Views, you can also set form properties in Form view and Datasheet view.

Note  When you set the AllowFilters property to No, you disable Filter By Selection, Filter By Form, Filter For Input, and Advanced Filter/Sort.