Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You cannot copy and paste a lookup field in a datasheet in Access 2010


View products that this article applies to.

Symptoms

You cannot copy and paste a lookup field in a datasheet in Microsoft Access 2010. Additionally, you cannot copy and paste a row or column that contains a lookup field.

↑ Back to the top


Cause

This problem occurs because the Access Services datasheet does not correctly handle the copy and paste operation for lookup fields. Lookup fields typically have two values: a bound value that is the foreign key to another table, and a display value that users can see. This problem occurs because the datasheet tries to paste the display value into the lookup field. Instead, the datasheet should paste the bound value into the lookup field.

↑ Back to the top


Workaround

To work around this problem, click the cell that you want to paste into, click the drop-down arrow to expand the combo box, and then paste the lookup field.

↑ Back to the top


Keywords: KB981238, kbexpertiseadvanced, kbprb, kbsurveynew, kbtshoot

↑ Back to the top

Article Info
Article ID : 981238
Revision : 4
Created on : 9/12/2011
Published on : 9/12/2011
Exists online : False
Views : 400