Microsoft KB Archive/236487

= ACC2000: Additional Controls Command Is Unavailable in Access =

Article ID: 236487

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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:
 * 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:

237359 MOD2000: COM Add-ins Using ActiveX Controls Cause Errors



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: kbnofix kbprb KB236487

-

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

© Microsoft Corporation. All rights reserved.