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

Bumping this

You could have a calculation of some sort at the end of each row which concatenates all the rows with the separator of your choice.

Say you have the Bob, Jim, and Tom in Row 1, A through C:

will return Bob Jim Tom. Alternatively, you can use the CHAR function to insert something other than a space or just type something else in quotes that suits you. You'll have to experiment with what pastes and doesn't.

Ahh thanks,

I am copying rows from columns B, C, and, D but they go up to H with a table to the side of H which uses information going back over 600 rows to calculate things. I can't really add a column in without messing historical calculations up.

How can I get around this?

Thank you so much for your help.

Phil

Use another sheet.

Thanks,

Sorry to be a pain but I'm fully self taught on Excel and only know the basics like creating formulas etc. I don't know much about manipulating the software. How would I use another sheet? It's probably simple but if yer don't know, yer don't know

Thank you

Add another sheet. Enter the formulas there just as you would on the original sheet. Or copy them from the original.

If you really need help doing it, post your sheet and I'll work it up for ya.

Thanks, I'll look into it further but I'm starting to think it is just as quick to copy and paste the three cells information into the text box in Access and just enter the two spaces myself.

Before, nothing was set up, it just added the little square automatically.

I wonder if it is a setting in the text box within Access form?

Thanks for your help.

Phil

P.S If I have to send the Excel thing up I'll have to create a dummy as this has sensitive customer info in it.