Display copy and past friendly report results

[jackyoung2012]

hi,

Is it possible to display a report with multiple fields in one text box. the reason I ask is I want to be able to copy and paste multiple fields as one block of text? the reason I need this is am building a database for client testimonials, and want to generate a block of text that somebody can just copy and paste, that contains the client name, date and referral all in one block. Currently it keeps all the components in separate boxes.



thanks!

[pbaldy]

It wouldn't be editable, but you can do:

=[Field1] & [Field2]

you can concatenate a space, comma or linefeed in between if desired.

[jackyoung2012]

thanks, is it possible to run this over multiple lines, so the testimonial is on top, with the client name and date underneath?

[pbaldy]

=[Field1] & vbCrLf & [Field2]

[jackyoung2012]

Thanks, but I cant seem to get this to work, typing in vbCrLf doesnt seem to put a space in. Also, what do I reference in the report, the query or the table? Basically, I want the text box to look like this

[FinalTestinmonial], [Date added]
[candidate name], [job role], [sector],[county]

where the names of the fields from the query results I need are as follows:

final testimonial - Field10
candidate name - Candidate
job role - New Position
sector - Vertical
county - Countycand

but no matter how much I play with it I cant seem to get it to work!

[jackyoung2012]

Right, scratch the above, I now have it nearly all sorted, but for some reason, the [Countycand] field, which should diplay the county name, now just displays the autokey number instead for the county it should be!

[jackyoung2012]

Just for info, the formula I am now using is:

=[Field10] & Chr$(13) & Chr$(10) & [Candidate] & "," & [New Position] & "," & [Countycand] & "," & [Date Added]

any ideas?

[pbaldy]

My apologies, the vbCrLf is only valid in VBA code. The Chr() codes are appropriate in a textbox. To your question, you reference whatever the source of the report is; the fields referenced must be in its record source. Does your query include a county name? Typically you'd link tables to get the name available, and reference the name field. If you're using a lookup field, that's likely your issue.