Menu Equivalents

RunCommand constants are designed to allow the built-in menu functionality to be used in code. I have tried to map the constants to their menu equivalent. However this is by no means an exact or complete list, especially as functions move between menu items in different versions of Access. Also the menus change as you work in different parts of Access. Select the menu that you require below.

Control Menus    Toolbars    Shortcut Menus    Debug    Edit    File    Format    Help
Insert    Query    Records    Relationships    Run    Tools    View    Window

Format Menu

Variations of this menu are available in the following areas of Access: Form Datasheet, Form Design, Query Datasheet, Report Design, Table Datasheet.

Menu Item
RunCommand Equivalent
Align - Bottom
acCmdAlignBottom
Align - Left
acCmdAlignLeft
Align - Right
acCmdAlignRight
Align - To Grid
acCmdAlignToGrid
Align - Top
acCmdAlignTop
Autoformat
acCmdAutoFormat
Bring To Front
acCmdBringToFront
Cells
acCmdFormatCells
Change To - Check Box
acCmdChangeToCheckBox
Change To - Combo Box
acCmdChangeToComboBox
Change To - Image
acCmdChangeToImage
Change To - Label
acCmdChangeToLabel
Change To - List Box
acCmdChangeToListBox
Change To - Option Button
acCmdChangeToOptionButton
Change To - Text Box
acCmdChangeToTextBox
Change To - Toggle Button
acCmdChangeToToggleButton
Column Width
acCmdColumnWidth
Font
acCmdFont
Freeze Column
acCmdFreezeColumn
Hide Columns
acCmdHideColumns
Horizontal Spacing - Decrease
acCmdHorizontalSpacingDecrease
Horizontal Spacing - Increase
acCmdHorizontalSpacingIncrease
Horizontal Spacing - Make Equal
acCmdHorizontalSpacingMakeEqual
Rename Column
acCmdRenameColumn
Row Height
acCmdRowHeight
Send To Back
acCmdSendToBack
Set Control Defaults
acCmdSetControlDefaults
Size - To Fit
acCmdSizeToFit
Size - To Grid
acCmdSizeToGrid
Size - To Narrowest
acCmdSizeToNarrowest
Size - To Shortest
acCmdAlignToShortest
Size - To Tallest
acCmdAlignToTallest
Size - To Widest
acCmdSizeToWidest
Snap To Grid
acCmdSnapToGrid
Unfreeze All Columns
acCmdUnfreezeAllColumns
Unhide Columns
acCmdUnhideColumns
Vertical Spacing - Decrease
acCmdVerticalSpacingDecrease
Vertical Spacing - Increase
acCmdVerticalSpacingIncrease
Vertical Spacing - Make Equal
acCmdVerticalSpacingMakeEqual

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