Microsoft KB Archive/96457

{|
 * width="100%"|

PRB: Cannot Paste Column If Focus Is on One Cell in Query
'Article ID: Q96457

Creation Date: 17-MAR-1993

Revision Date: 16-OCT-1996' The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1, 2.0, 7.0

SYMPTOMS

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

If you cut or copy a query grid column, you can paste it back only if a column is selected. If there is no selection (that is, if the focus is on a single cell), all information is erroneously pasted into one cell. This same behavior occurs when copying and pasting a query grid row.

CAUSE

Before you paste information from the Clipboard, select an object that has the same size as the information in the Clipboard. In this example, select an entire column when you paste the information into the query grid.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior


 * 1) Create a query.
 * 2) Select an entire column in the Query Grid (click the mouse once at the top of a column when the mouse pointer changes to a DOWN arrow).
 * 3) On the Edit menu, click either Cut or Copy.
 * 4) Select a cell (to paste the copied column into) and click Paste on the Edit menu.

Note that the pasted values are not correct. The initial value is probably a 1, which indicates that the Show box was selected in the column you copied. You can scroll through values in the cell by using the UP and DOWN arrow keys. If you attempt to move off the cell by clicking elsewhere on the grid, you receive a syntax error message. When you cut or copy a row to the Clipboard, the row is copied to the Clipboard as tab-separated data. When you paste a row into a single cell, the tabs appear as rectangular characters.

This behavior occurs pasting into any object in Microsoft Access.

REFERENCES

For more information about the query grid, search for &quot;grid (queries and filters)&quot; using the Microsoft Access for Windows 95 Help Index.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kbusage

KBSubcategory: QryOthr

Additional reference words: 1.00 1.10 2.00 7.00