Microsoft KB Archive/207837

= ACC2000: Access Keys Do Not Work in Table and Query Datasheet View =

Article ID: 207837

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q207837



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you create access keys for table or query fields by typing an ampersand (&) in the Caption property of table or query fields, the access keys do not work in table or query Datasheet view. The literal ampersand characters appear in the field names, and the characters that you intended to be underlined do not have underlines.



CAUSE
Access keys are not functional in table or query Datasheet view.



MORE INFORMATION
Although the access keys that you create in the Caption property of table or query fields will not work in Datasheet view of the table or query, forms based on the table or query will inherit the functioning access keys in both Datasheet view and Form view.

Steps to Reproduce Behavior

 * 1) Open any database and create a new table named Table1 in Design view.
 * 2) Create two fields, Field1 and Field2, and set the data type to Text.
 * 3) Set the Caption property of Field1 to Field&1 and the Caption property of Field2 to Field&2.
 * 4) Close and save the Table1 table. You do not need to define a primary key.
 * 5) Open the Table1 table in Datasheet view. Note that Datasheet column names appear as Field&1 and Field&2, and that the numbers 1 and 2 in the column names are not underlined.
 * 6) Close the table.
 * 7) In the Database window, make sure that the Table1 table is selected. Click the New Object button on the Database toolbar, and then click AutoForm on the menu that appears. Note that when the Table1 form is created in Form view, Field1 and Field2 appear with the numbers underlined, and if you press the ALT+1 or ALT+2 key combination, the focus moves to the respective fields.
 * 8) Switch the Table1 form to Datasheet view by clicking Datasheet View on the View menu. Note that in Datasheet view, Field1 and Field2 also appear with the numbers underlined, and if you press the ALT+1 or ALT+2 key combination, the focus moves to the respective fields.

