Select fields and records

ShowSelect fields and records in a datasheet

The following table lists mouse techniques for selecting data or records in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).

To select Click
Data in a field Where you want to start selecting and drag across the data.
An entire field The left edge of the field in a datasheet, where the pointer changes into Button image.
Adjacent fields The left edge of a field and drag to extend the selection.
A column The field selector (field selector: A small box or bar that you click to select an entire column in a datasheet.).
Adjacent columns The field name at the top of the column and then drag to extend the selection.
A record The record selector (record selector: A small box or bar to the left of a record that you can click to select the entire record in Datasheet view and Form view.).
Multiple records The record selector of the first record, and then drag to extend the selection.
All records Select All Records on the Edit menu.

ShowSelect fields and records in a data access page

The following table lists mouse techniques for selecting data or records in Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Microsoft Internet Explorer 5.0 or later.).

To select Click
Data in a field Where you want to start selecting and drag across the data
An entire field Three times within the field
A record A field that belongs to the record


The following table lists keyboard techniques for selecting data or records in Page view.

To select Do this
Data in a field Move the insertion point to the start of the text you want to select, and then hold down SHIFT and press the arrow keys to move to the end of the selection.
An entire field Move the insertion point to anywhere in the field, press HOME, and then press SHIFT+END.
A record Press TAB until a field that belongs to the record gets focus.


Note      Your data access page might have a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component, which have their own methods of selection. To display Help for one of these components, click Help Button image on its toolbar.

 
 
Applies to:
Access 2003