ACC2000: Cannot Insert DataCombo or DataList Controls in Access Forms (249616)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q249616
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 are unable to insert the Microsoft DataCombo or DataList ActiveX controls into Microsoft Access forms and reports.

CAUSE

These controls require advanced data-binding support by the ActiveX Control container. Microsoft Access 2000 does not offer advanced data-binding support for ActiveX controls; therefore, these controls are not listed in the Insert ActiveX Control dialog box.

STATUS

This behavior is by design.

MORE INFORMATION

The DataCombo and DataList controls (Msdatlst.ocx) are installed as part of Microsoft Office 2000 Developer. Both the DataCombo and DataList controls can be inserted into UserForms in the Visual Basic Environment (VBE) and in data access pages with the Microsoft Script Editor.

For additional information about UserForms in Access, click the article number below to view the article in the Microsoft Knowledge Base:

198646 ACC2000: Access 2000 Does Not Support the UserForm Object

Steps to Reproduce the Behavior

  1. Install Microsoft Office 2000 Developer or another product, such as Microsoft Visual Studio 6.0, so that the DataCombo and DataList ActiveX controls are installed on your computer.
  2. Start Microsoft Access.
  3. Open the sample database Northwind.mdb.
  4. Open a new, blank form in Design view.
  5. On the Insert menu, click ActiveX Control.

    Note that the list does not contain an entry for the Microsoft DataCombo or DataList controls.
  6. Click Cancel to close the Insert ActiveX Control dialog box.

REFERENCES

For additional information about the ActiveX Control features supported by Microsoft Access, click the article number below to view the article in the Microsoft Knowledge Base:

202104 ACC2000: Custom ActiveX Control Features Supported in Access


Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb KB249616