AllowSpecialKeys property

Applies to: Access 2013 | Access 2016

Use the AllowSpecialKeys property to specify whether or not special key sequences (ALT+F1 (F11), CTRL+F11, CTRL+BREAK, and CTRL+G) are disabled or enabled. For example, you can use the AllowSpecialKeys property to prevent a user from displaying the Database window by pressing F11, entering break mode within a Visual Basic module by pressing CTRL+BREAK, or displaying the Immediate window by pressing CTRL+G.

Setting

The AllowSpecialKeys property uses the following settings.

Setting Description
True (-1) Enable the special key sequences.
False (0) Disable the special key sequences.

The easiest way to set this property is by using the Use Access Special Keys option in the Current Database section of the Access Options dialog box.

To view the Access Options dialog box, click the Microsoft Office button File menu button, and then click Access Options. In a Microsoft Access database, you can also set this property by using a macro or Visual Basic.

To set the AllowSpecialKeys property by using a macro or Visual Basic, you must first either set the property in the Access Options dialog box once or create the property in the following ways:

  • In a Microsoft Access database, you can add it by using the CreateProperty method and append it to the Properties collection of the Database object.

  • In a Microsoft Access project (.adp), you can add it to the AccessObjectProperties collection of the CurrentProject object by using the Add method.

Remarks

You should make sure the AllowSpecialKeys property is set to True when debugging an application.

The AllowSpecialKeys property affects the following key sequences.

Key sequences Effect
ALT+F1 (F11) Display the Navigation Pane.
CTRL+G Display the Immediate window.
CTRL+F11 Toggle between the custom menu bar and the built-in menu bar.
CTRL+BREAK Enter break mode and display the current module in the Code window.

This property's setting doesn't take effect until the next time the application database opens.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.