Displaying Multiple Items

  • Thread starter Thread starter JZ
  • Start date Start date
J

JZ

On a form the user choses multiple topics that are
associated with their program (Relationship: One Class
can have Many Topics). Near the class title(on a roster)I
want to display each topic that was selected. Currently
you have to read the topics from top to bottom because I
have my "Topic" field in the detail section under the
class heading. Is there a way to have these topics display
from left to right one right after another if more than on
topic was selected?

Ex: TopicA, TopicB, TopicC,
 
Not sure I understand, but perhaps your topics could be in
a subreport. If so, in the subreport's page setup, set
the columns to go across, then down. Another possibility
might be a concatenated value in a text box or query. It
depends on how you have set up your database. If you need
more than this, you will need to supply some more details
about the database.
 
JZ said:
On a form the user choses multiple topics that are
associated with their program (Relationship: One Class
can have Many Topics). Near the class title(on a roster)I
want to display each topic that was selected. Currently
you have to read the topics from top to bottom because I
have my "Topic" field in the detail section under the
class heading. Is there a way to have these topics display
from left to right one right after another if more than on
topic was selected?

Ex: TopicA, TopicB, TopicC,
Click to expand...


Duane has a function to help do this:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
 
Back
Top