ACC2000: Pasted Field from Datasheet View Includes Column Name
ID: Q198917
|
The information in this article applies to:
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
If you select and copy the data in a cell of a table, a query, or a form in
Datasheet view and you paste the data elsewhere, the data includes the
name of the column in the datasheet.
CAUSE
You selected the entire cell, not just the data in the cell. When you
select and copy an entire cell in Datasheet view, Microsoft Access
automatically includes the column name.
MORE INFORMATION
Microsoft Access provides two ways to copy and paste data from a cell in
Datasheet view. You can select and copy just the data itself, or you can
select and copy the entire cell. By default, copying the entire cell
includes the column name.
Selecting and Copying Only the Data in a Cell
- Open your table, query, or form in Datasheet view.
- Click inside a cell where you want to begin selecting data, and drag
the mouse pointer across the data. Make sure the pointer is an I-beam
shape while you drag.
If you want to use your keyboard to select all the data in a cell
without selecting the column name, click anywhere inside the cell and
press F2.
NOTE: By using these methods, you can only select the data in a single cell of the datasheet.
Selecting and Copying an Entire Cell or Multiple Cells
Whenever you select and copy an entire cell or multiple cells in your
datasheet, Microsoft Access automatically includes the column name(s) when
you paste the data.
- Open your table, query, or form in Datasheet view.
- Point to the left or the upper edge of the cell until your pointer
changes to a plus (+) shape.
- Click, and note that the entire cell is selected. If you copy and paste the data into another application, such as Notepad or Microsoft Excel, the column name will also be pasted.
If you want to select multiple cells, in step 3, drag the pointer over the
cells that you want instead of clicking in one cell.
REFERENCES
For more information about ways to copy or move data, click Microsoft Access Help on the
Help menu, type "copy or move items" in the Office Assistant or the Answer Wizard,
and then click Search to view the topic.
For more information about how to select fields and records in Datasheet, click Microsoft Access Help on the
Help menu, type "selecting fields and records in datasheet view" in the Office Assistant or the Answer Wizard,
and then click Search to view the topic.
Additional query words:
paste cursor select highlight field column prb
Keywords : kbui kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb