Producing lists across the report page.

[davidrsutton]

I have a table with an EMail address field in it. I want to be able to produce a report that simply lists them across the page followed by a comma and a space. e.g.
"someone@somewhere.com, someoneelse@somewhereelse.com, eggg@egg.com, rf@fr.com, whatever@bum.com" etc for about 2000 EMail addresses.

Any ideas would be greatly appreciated

 

[dhookom]

Try the sample code in faq701-4233. There is a demo of this at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]