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

ID: Q207837

The information in this article applies to:
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.



REFERENCES

For more information about access keys, click Microsoft Access Help on the Help menu, type "Assign an access key to a menu or command" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: shortcut 


Keywords          : kbui UifDatash 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999