Concatenate multiple records into one text string

[Danny]

Greetings.

I have a form with subforms, that displays multiple
child records for the displayed parent record. These child
records - which contain only one field - display in a
column. But for records with lots of child records, this
column is taking up too much space on the report.

Is there a way to replace the subform with a text box that
display a string of values separated by commas instead? Is
there a way to render multiple records as a connected
string of values separated my commas?

Thanks for your help.

Danny

 

[Allen Browne]

You can write a function that returns the related values as a string.

Details:
http://www.mvps.org/access/modules/mdl0004.htm

 

[Danny]

Thanks for the help, Allen. I'll give this a try.

Danny