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. 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.

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 acCmdF

Constant
Value
Description
acCmdFavoritesAddTo
299
Displays the Add To Favorites dialog
acCmdFavoritesOpen
298
Displays the Open Favorites dialog
Code ExampleacCmdFieldList
42
Display/hide the Field List dialog
acCmdFieldTemplates
647
 
Code ExampleacCmdFilterByForm
207
Displays the filter by form dialog
Code ExampleacCmdFilterBySelection
208
Filters the displayed records by the selected item
Code ExampleacCmdFilterExcludingSelection
277
Filters out records that match selection
acCmdFilterMenu
619
 
Code ExampleacCmdFind
30
Opens the Find dialog box. Available in both VBE and non-VBE views
Code ExampleacCmdFindNext
341
Finds next occurrence of previously searched for phrase. Available in both VBE and non-VBE views
acCmdFindNextWordUnderCursor
313
Finds the next occurrence of the word which is under the cursor. Not really Edit Find but an improvement on it
acCmdFindPrevious
120
Find previous occurrence of the last string searched for. Not really Edit Find but an enhancement
acCmdFindPrevWordUnderCursor
312
Finds the previous occurrence of the word which is under the cursor. Equivalent to Ctrl Shift and F3
Code ExampleacCmdFitToWindow
245
Fit print preview in window
Code ExampleacCmdFont
19
Display the font selection dialog
acCmdFormatCells
77
Displays the Format Cells dialog
Code ExampleacCmdFormHdrFtr
36
Adds or removes form headers and footers
Code ExampleacCmdFormView
281
Switches to form view
Code ExampleacCmdFreezeColumn
105
Keeps the selected column in view

© 1998 - 2011 Terry Wickenden TKW Design Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.