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


The information in this article applies to:

  • Microsoft Access 2000
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.
Modification Type:MinorLast Reviewed:7/14/2004
Keywords:kbbug kbDAP kbpending KB225903
©2004 Microsoft Corporation. All rights reserved.