ACC2000: Shortcut Keys May Not Work in Access Project (223201)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q223201
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

Certain shortcut keys that you use in Microsoft Access databases (.mdb files) do not function as expected when you use them in Microsoft Access projects (.adp files).

MORE INFORMATION

For example, the CTRL+ALT+SPACEBAR shortcut key combination inserts the default value in an Access form. However, this shortcut key combination causes an Access project form to move to the first record.

The following table shows if a shortcut key combination available in an Access database has the same functionality in an Access project:

Shortcut KeyUse in Access databaseSame functionality in Access project?
CTRL+SEMICOLON (;)To insert the current dateYes
CTRL+COLON (:)To insert the current timeYes
CTRL+ALT+SPACEBARTo insert the default value for a fieldNo
CTRL+APOSTROPHE (')To insert the value from the same field in the previous recordYes
CTRL+PLUS SIGN (+)To add a new recordYes
CTRL+MINUS SIGN (-)To delete the current recordYes
SHIFT+ENTERTo save changes to the current recordYes
SPACEBARTo switch between the values in a check box or option buttonYes
CTRL+ENTERTo insert a new lineYes
F9To recalculate the fields in the window or to refresh the contents of a Lookup field list box or combo boxNo
SHIFT+F9To requery the underlying tables; in a subform, this requeries the underlying table for the sub-form onlyNo

REFERENCES

For more information about shortcut keys, click Microsoft Access Help on the Help menu, type keyboard shortcuts in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kbprb KB223201
©2004 Microsoft Corporation. All rights reserved.