Full List of All RunCommand Constants

Here is a complete list of RunCommand constants with a description of their function where I know what they do. Both the list in Access Help and the list obtainable on the Microsoft Web Site are incomplete and contradict one another.

I have colour coded the list dependent on the version in which they first appeared - Access 97, Access 2000, Access XP, Access 2003 or Access 2007. Prior to Access 2007, all later versions of Access recognise the earlier commands. See Known Problems for more details. Some of these were retained for backwards compatibility only. If you spot any errors or can fill the gaps please let me know.

Code Link links to code examples for that constant. Select the start letter, ignoring the acCmd, of the constant.

Select the sixth letter of the acCmdConstant
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Constants starting acCmdV

Constant
Description
Value

Code ExampleacCmdVerticalSpacingDecrease
Decreases the vertical space between selected objects
161

Code ExampleacCmdVerticalSpacingIncrease
Increases the vertical space between selected objects
162

Code ExampleacCmdVerticalSpacingMakeEqual
Makes the vertical space between selected objects equal
160

Code ExampleacCmdViewCode
Opens the Code window for the selected object
170

Code ExampleacCmdViewDataAccessPages
Displays the Pages tab in Database Window
349

acCmdViewDetails
Displays details in database window
210

acCmdViewDiagrams
Displays the Diagrams tab of the database window of an Access Data Project
354

acCmdViewFieldList
Displays and hides the Field List in a View
353

Code ExampleacCmdViewForms
Displays the Form tab in Database Window
112

acCmdViewFunctions
 
395

acCmdViewGrid
Toggles display of the Grid in form and report design view
63

acCmdViewLargeIcons
Displays large icons in database window
209

acCmdViewList
Displays items in a list in the database window
212

Code ExampleacCmdViewMacros
Displays the Macro tab in Database Window
114

Code ExampleacCmdViewModules
Displays the Module tab in Database Window
115

acCmdViewObjectDependencies
 
536

Code ExampleacCmdViewQueries
Displays the Query tab in Database Window
111

Code ExampleacCmdViewReports
Displays the Report tab in Database Window
113

Code ExampleacCmdViewRuler
Toggles the display of the ruler in form and report design
61

acCmdViewShowPaneDiagram
Toggles the display of the Diagram Pane when in the design of a View
358

acCmdViewShowPaneGrid
Toggles the display of the Grid Pane when in the design of a View
359

acCmdViewShowPaneSQL
Toggles the display of the SQL Pane when in the design of a View
357

acCmdViewSmallIcons
Displays small icons in database window
211

acCmdViewStoredProcedures
Displays the Stored Procedures tab of the database window in an Access Data Project
355

acCmdViewTableColumnNames
 
363

acCmdViewTableColumnProperties
 
368

acCmdViewTableKeys
 
369

acCmdViewTableNameOnly
 
364

Code ExampleacCmdViewTables
Displays the Table tab in Database Window
110

acCmdViewTableUserView
 
370

Code ExampleacCmdViewToolbox
Toggles the display of the Toolbox in form and report design
85

acCmdViewVerifySQL
Verifies the SQL in the design of a View
360

Code Example acCmdViewViews
Display the views tab of the database window in an Access Data Project
356

acCmdVisualBasicEditor
Opens the Visual Basic Editor
525