ACC2000: Additional Controls Command Is Unavailable in Access

ID: Q236487

The information in this article applies to:
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills.

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


SYMPTOMS

In Design view of a user form in Microsoft Access, you do not see the Additional Controls command on the shortcut menu of the toolbox when you right-click the toolbox. In other programs that uses the Visual Basic Environment, such as Microsoft Excel and Microsoft Word, you do see this command.


CAUSE

Microsoft Access does not make this command available on the shortcut menu of the toolbox because user forms are not the primary form interface supported by Access.


RESOLUTION

You can use many of the same controls available on the Additional Controls menu in a typical Microsoft Access 2000 form.

If your solution requires that you use user forms and the additional controls, you can customize the menu bar to include the Additional Controls command. To do so, follow these steps:

  1. Press ALT+ F11 to open the Visual Basic Editor.


  2. On the View menu, point to Toolbars, and then click Customize.


  3. Click the Commands tab.


  4. In the Categories list, click Tools.


  5. Drag Additional Controls from the Commands list to the Insert menu.


  6. Click Close.


If you want to add controls to the UserForm toolbox, click Additional Controls on the Insert menu.

NOTE: There are some limitations when you use user forms with certain controls in COM add-ins. For more information about these limitations, see the following article in the Microsoft Knowledge Base:
Q237359 MOD2000: COM Add-ins Using ActiveX Controls Cause Errors


MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a new database in Access and press ALT+F11.


  2. If UserForm appears on the Insert menu, skip to step 8.


  3. On the View menu, point to Toolbars, and then click Customize.


  4. Click the Command tab. In the Categories list, click Insert.


  5. In the Commands list, locate UserForm.


  6. Click UserForm, hold down the left mouse button, and drag UserForm to the Insert menu. Place UserForm under Class Module, and then release the mouse button.


  7. Close the Customize dialog box.


  8. On the Insert menu, click UserForm.


  9. Double-click UserForm1.


  10. If the toolbox is not displayed, on the View Menu, click ToolBox.


  11. Right-click the toolbox. Note that there is no Additional Controls command.


Additional query words: prb ocx custom control

Keywords : kbdta FmsOthr
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: August 11, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.