Sub report -- minimize space

[Perry Kew]

In Access 2002 I would like to create a sub-report in a
report. The subreport lists the names of the children of
people participating in an event.

The subreport field is reported in its own footer. If
there are three children, three lines of space are taken
up. I was wondering if it is possible to list the names
horizontally rather than vertically. There is only field
in the subreport and I would like to get them horizontally
to save space.

Any ideas?

Thank you.

 

[Fons Ponsioen]

You could try to format thesubreport for colums, the way
to do that is open the subreport in design mode and than
go to the page setup.
Hope this helps
Fons

 

[Marshall Barton]

In Access 2002 I would like to create a sub-report in a
report. The subreport lists the names of the children of
people participating in an event.

The subreport field is reported in its own footer. If
there are three children, three lines of space are taken
up. I was wondering if it is possible to list the names
horizontally rather than vertically. There is only field
in the subreport and I would like to get them horizontally
to save space.

Make the subreport's design area as narrow as you can. Then
use the File - Page Setup - Columns menu item to specify as
many columns as you can fit in the available space. Close
and save the modified design of the subreport.

Now make the subreport control (on the main report) as wide
as you can. Preview the main report to see what it looks
like and adjust as best you can.

There is another way to get a related table's records into a
list by using a function instead of a subreport. If you
want to pursue this approach, take a look at Duane Hookom's
Concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane