ACC2000: Additional Controls Command Is Unavailable in Access (236487)
The information in this article applies to:
This article was previously published under Q236487 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
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:
- Press ALT+ F11 to open the Visual Basic Editor.
- On the View menu, point to Toolbars, and then click Customize.
- Click the Commands tab.
- In the Categories list, click Tools.
- Drag Additional Controls from the Commands list to the Insert menu.
- 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:
237359 MOD2000: COM Add-ins Using ActiveX Controls Cause Errors
Modification Type: | Minor | Last Reviewed: | 7/15/2004 |
---|
Keywords: | kbnofix kbprb KB236487 |
---|
|