Microsoft KB Archive/199976

= ACC2000: Can't Filter by Partial Selection in Data Access Page =

Article ID: 199976

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q199976



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
You may not get the records you expect when you use Filter by Selection on a data access page.



CAUSE
When a bound field has focus, Filter by Selection filters based on the entire contents of the control, even if you have only a portion of the text in that control selected. For example, if you have the word "Confections" in a control, you cannot select just the first two letters and use Filter by Selection to filter all records that start with "Co" (or Like Co*). In a data access page, the filter will result in only records that contain the whole word, "Confections."



MORE INFORMATION
Filter by Selection in a data access page does not use a partial selection as does Filter by Selection in a form.

Filter By Selection in data access pages is additive. If you apply a filter for the value of one field and then filter on another field without removing the first filter, the resulting filter will be an AND of the two filters. The Filter toggle button will remove and reapply the filter created during a session.

Steps to Reproduce Behavior
 Open the Customers form in the sample database Northwind.mdb. If you have not made any changes to the Northwind.mdb, There should be 91 records. Click just the "A" of ALFKI in the CustomerID field. On the Records menu, click Filter, and then click Filter by Selection. Note that the filter limits the number of records to four.  Create a new data access page named Customers and set the following property:   RecordSource: Table: Customers   On the Edit menu, click Select Page and change the following property: <pre class="fixed_text">  Id: Customers </li>  Add the following controls to the Customers page and set the properties of the controls as indicated: <pre class="fixed_text">  Text Box Id: CustomerID ControlSource: CustomerID

Text Box Id: CompanyName ControlSource: CompanyName </li> On the View menu, click Page View. Note that there are 91 records.</li> Select just the "A" of ALFKI in CustomerID field.</li> On the Navigation control, click Filter by Selection. Note that the filter limits the number of records to one.</li></ol>

Additional query words: DAP prb can t cannot

Keywords: kbdap kbprb KB199976

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.