View Single Post
  #2  
Old June 3rd, 2010, 11:19 AM posted to microsoft.public.access.reports
Wolfgang Kais[_4_]
external usenet poster
 
Posts: 18
Default Display multiple records from same ControlSource

Hello "H".

"SummitSeeker" wrote:
I am trying to display multiple records in one text box on a report.
I can get it to work if I put the text box in the "Details" section
of the report, but I need it to be displayed at the bottom of the
report.

Is there a way to move the "Details" Section to the bottom of the
report?

No.

Is there a way to get more than one resord to be displayed in one
text box?


No.

Thanks like always for the help...


The report header/footer or a form header/footer is a section that is
only not repeated, but in general all other sections like page header
or footer, group header or footer and also the details section is
ment to be repeated several times. Especially the details section is
repeated for every record of the record source of the form or report.
Therefore, if you see multiple textboxes displaying data from multiple
records, it's not one textbox that contains multiple records, instead
there are multiple copies of the details section, one for each record.
(In VB6, to achieve the same result, one had to create a custom
control for that section that was repeated in a DataRepeater control.)
The is a predefined order or hirarchy of sections in a report that can
not be changed. From what you describe, it seems to me that you want
to display a list of certain items in the report footer. To achieve
this, you may have to create a report that only displays your list
(maybe containing only a details section that repeats a textbox) and
place it as a subreport in the report footer of your report.

--
Regards,
Wolfgang