A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Display multiple records from same ControlSource



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 06:43 PM posted to microsoft.public.access.reports
SummitSeeker
external usenet poster
 
Posts: 3
Default Display multiple records from same ControlSource

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?

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

Thanks like always for the help...
-H-


  #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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.