Copy and paste plain text.

[316854]

I want to copy and paste this:



Field 1

Field 2
Field 2
Field 2

Field 1

Field 2
Field 2
Field 2

Here's an example:

John Smith

987445
168153
687451

James Jones

135168
654132
415156



It seems that I can't copy and paste from reports in that way.

What do I do?

Thanks.

[orange]

How about 3-4 lines of what this means in plain English?

[316854]

When I copy from a report and paste it into, for example, notepad, this happens:

John Smith 987445
John Smith 168153
John Smith 687451
James Jones 135168
James Jones 654132
James Jones 415156

I want this to be pasted:

John Smith

987445
168153
687451

James Jones

135168
654132
415156

[orange]

You have to break the original text the way you want it to appear, then copy and paste the pieces.

[316854]

Can you give me an example?

[orange]

Start with
John Smith 987445
John Smith 168153
John Smith 687451
James Jones 135168
James Jones 654132
James Jones 415156

Copy
John Smith and paste it wherever
Copy
987445 and paste it
oopy
168153 and paste it
Copy
687451 and paste it
etc.....

[316854]

It seems there's no convenient way to copy and paste from access in the way that I want.

Is that correct?

I don't want to copy and paste individual pieces of information.

I want to copy everything all at once and paste it all at once.

[orange]

Well - copy then paste.
But you said you wanted this output:

I want this to be pasted:

John Smith

987445
168153
687451

James Jones

135168
654132
415156

What exactly do you want?

[316854]

I do not want this to be pasted, but this is what access keeps giving me:

John Smith 987445
John Smith 168153
John Smith 687451
James Jones 135168
James Jones 654132
James Jones 415156

I want a report to look like this, and also what I paste to look like this:

John Smith

987445
168153
687451

James Jones

135168
654132
415156

I want to simply highlight the entire report, and paste it into notepad, but I don't want this:

John Smith 987445
John Smith 168153
John Smith 687451
James Jones 135168
James Jones 654132
James Jones 415156

[316854]

I found a partial solution.

I can use a label box to create a line break.

I can export to pdf and copy from it.

However, how is a blank label box made?

I need to somehow create line breaks.

I need to get this into notepad:

John Smith

987445
168153
687451

James Jones

135168
654132
415156