CommandEnabled Event [Access 2003 VBA Language Reference]

Occurs when the specified Microsoft Office Web Component determines whether the specified command is enabled.

Private Sub Form_CommandEnabled(ByVal Command As Variant, ByVal Enabled As Object)

Command   The command that has been verified as being enabled.

Enabled   Set the Value property of this object to False to disable the command.


The OCCommandId, ChartCommandIdEnum, and PivotCommandId constants contain lists of the supported commands for each Web component.


The following example demonstrates the syntax for a subroutine that traps the CommandEnabled event.

Private Sub Form_CommandEnabled( _
        ByVal Command As Variant, ByVal Enabled As Object)   Dim intResponse As Integer
    Dim strPrompt As String

    strPrompt = "Disable the command?"

    intResponse = MsgBox(strPrompt, vbYesNo)

    If intResponse = vbYes Then
        Enabled.Value = False
        Enabled.Value = True
    End If
End Sub

Applies to | Form Object