suppressing line feeds in the detail part of a report

  • Thread starter Thread starter John MilburySteen
  • Start date Start date
J

John MilburySteen

Hi Access Gurus,



In A2000, I need to write a report that contains email addresses that a user
can cut and paste into the TO: line of her email program. It would look
like this:



(e-mail address removed); (e-mail address removed); (e-mail address removed);



(These are not intended to be real email addresses.)



It would be quite straightforward to write a report that outputs this:



(e-mail address removed);

(e-mail address removed);

(e-mail address removed);



I could do that easily, but this is not what the user wants.



1. Is there any way to suppress the line feed in the detail part of the
report?

2. Should I just tell the user to write the report to Word and then remove
the line feeds herself, using Find and Replace?



Note the user will not accept a CSV file which loads an address book into
the email editor.

And I do not do VBasic programming.
 
John MilburySteen said:
In A2000, I need to write a report that contains email addresses that a
user can cut and paste into the TO: line of her email program. [snip]
And I do not do VBasic programming.
Click to expand...

To concatenate the email addresses together into one line string, use a VBA
function like this:
http://allenbrowne.com/func-concat.html

For example, if the table is named Clients, and the field is named Email,
use a text box with Control Source of:
=ConcatRelated("Email", "Clients")

Note that there is no code to write. Just follow the 4 steps to add the
function to your database, and you can use it as above.
 
Back
Top