Microsoft KB Archive/225903

= ACC2000: Field That You Add to a Data Access Page Does Not Match the Lookup DisplayControl Type =

Article ID: 225903

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225903





Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you drag a field onto a data access page, Microsoft Access does not automatically create a control that matches the control type that you specified in the DisplayControl property for that field (on the Lookup tab of the table's Field Properties section).



CAUSE
Data access pages do not have access to the Microsoft Jet property manager when you create a page without using a wizard.



RESOLUTION
There are two possible solutions for this problem:
 * Use the toolbox to add the type of control that you want to have on the page. Then, set the ControlSource property of this unbound control to the field that you want to bind to the control.
 * Use a page wizard to build the page. If you build the page by using a wizard, the wizard will interact with Jet during the creation of the page, and the wizard will create controls on the page that match the type of properties assigned to each field.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
Unlike other Access database objects, data access pages do not have an immediate connection to the data source. For example, an Access form has a direct connection to the data source to which it is bound at all times, even when the form is in Design view.

Although you can specify the data source for a data access page in Design view of the page, the page is only bound to its source while the page is in Page view. Therefore, when you manually add fields to a page, there is no interaction with Jet, the provider for the properties of each field.

Steps to Reproduce the Behavior
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.


 * 1) Open the sample database Northwind.mdb.
 * 2) In the Database window, click Tables under Objects, click the Products table, and then click Design view.
 * 3) Click the Discontinued field to view its field properties.
 * 4) Click the Lookup tab, and then change the DisplayControl property to Text Box.
 * 5) Close the table, and click Yes to save the changes.
 * 6) In the Database window, click Pages under Objects, and then click New.
 * 7) In the New Data Access Page dialog box, click Design View, click Products in the Choose the table or query where the object's data comes from box, and then click OK.
 * 8) If the field list is not displayed, click Field List on the View menu.
 * 9) Drag the Discontinued field into the Section: Unbound section.

Note that Microsoft Access adds or creates the default control type for a Boolean field to the page, which is a check box. This occurs even though you specified a control type of text box.

Additional query words: pra DAP DAPs drag-and-drop drag/drop

Keywords: kbbug kbdap kbpending KB225903

-

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

© Microsoft Corporation. All rights reserved.