Copy from Excel to Access

[GMC Phil]

Hello folks,

I used to be able to copy a row of cells into a text box in an Access form in Office 2000 (maybe 2003 I can't quite remember). The result was a little square in between the figures from each cell. I now have Windows 10 and Office 2007 and it just copies it as a string of numbers without the square or even a space. This means me going and manually entering a space to show the figures from each individual cell.

Is there any way of making this happen? I've been using it for years as it was and would like it how it was if possible.

Thanks for taking the time to read this.

Cheers



Phil