Single Copy and Multiple paste operation:

[teja]

Hi all,

I observed that when I copy a value, select a range of columns and try to copy in the entire range of cells, the value is pasted only in the beginning cell and rest all are empty.

But i have a requirement when after selecting the range of cells in the table and press Ctl+V the user should be able to paste the values in all the selected range of cells as in excel.

Is there a setting or something in Access for this functionality??

Kindly help. Thanks in advance.

 

[teja]

copy the value, close the excel sheet and then paste in the range of cells in the access table.

 

[vbaInet]

If you highlight the new row in the Query (that is bound to the table) and Paste, it should fill down.