Here is a complete list of RunCommand constants with a description of their function where I know what they do.
The list in Access Help and the one 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, Access 2007 or Access 2010. 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.
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
Value
Description
acCmdVerticalSpacingDecrease
161
Decreases the vertical space between selected objects
acCmdVerticalSpacingIncrease
162
Increases the vertical space between selected objects
acCmdVerticalSpacingMakeEqual
160
Makes the vertical space between selected objects equal
acCmdViewCode
170
Opens the Code window for the selected object
acCmdViewDataAccessPages
349
Displays the Pages tab in Database Window
acCmdViewDetails
210
Displays details in database window
acCmdViewDiagrams
354
Displays the Diagrams tab of the database window of an Access Data Project
acCmdViewFieldList
353
Displays and hides the Field List in a View
acCmdViewForms
112
Displays the Form tab in Database Window
acCmdViewGrid
63
Toggles display of the Grid in form and report design view
acCmdViewLargeIcons
209
Displays large icons in database window
acCmdViewList
212
Displays items in a list in the database window
acCmdViewMacros
114
Displays the Macro tab in Database Window
acCmdViewModules
115
Displays the Module tab in Database Window
acCmdViewObjectDependencies
536
acCmdViewQueries
111
Displays the Query tab in Database Window
acCmdViewReports
113
Displays the Report tab in Database Window
acCmdViewRuler
61
Toggles the display of the ruler in form and report design
acCmdViewShowPaneDiagram
358
Toggles the display of the Diagram Pane when in the design of a View
acCmdViewShowPaneGrid
359
Toggles the display of the Grid Pane when in the design of a View
acCmdViewShowPaneSQL
357
Toggles the display of the SQL Pane when in the design of a View
acCmdViewSmallIcons
211
Displays small icons in database window
acCmdViewStoredProcedures
355
Displays the Stored Procedures tab of the database window in an Access Data Project
acCmdViewTableColumnNames
363
acCmdViewTableColumnProperties
368
acCmdViewTableNameOnly
364
acCmdViewTables
110
Displays the Table tab in Database Window
acCmdViewTableUserView
370
acCmdViewToolbox
85
Toggles the display of the Toolbox in form and report design
acCmdViewVerifySQL
360
Verifies the SQL in the design of a View
acCmdViewViews
356
Display the views tab of the database window in an Access Data Project
acCmdVisualBasicEditor
525
Opens the Visual Basic Editor
Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.