How do you beat the 22" high report limitation in Access

[Guest]

I am trying to create a report for a small database that was created for
storing interview comments. The fields (20 or so) are all Memo and contain
short paragraphs of text from the interviews. When I create my report and
try to bring in my controls and fields I run out of room in the detail
section and cannot expand the section past 22" (the Access limit). Is there
any way to beat this limitation and fit all of my data on one report? Thanks
for any advice. Greg

 

[Duane Hookom]

I would expect the 20 or so memo fields to be in separate records in a table
with one memo field. This would create a more normalized table structure. It
would also allow you to easily add more interview questions without changing
anything in your application.

However, you can create additional groupings in your report based on your
table's primary key. View the headers and footers of these groups to
"expand" your detail section.

 

[Rick Brandt]

I am trying to create a report for a small database that was created
for storing interview comments. The fields (20 or so) are all Memo
and contain short paragraphs of text from the interviews. When I
create my report and try to bring in my controls and fields I run out
of room in the detail section and cannot expand the section past 22"
(the Access limit). Is there any way to beat this limitation and fit
all of my data on one report? Thanks for any advice. Greg

Are you making the controls small (vertically) with CanGrow enabled? The 22
inch limit is "hard", but it is per-section so you can simply make more
sections. Another option is to use subreports.

 

[Guest]

Duane, thanks for getting back to me. I am pretty sure that is the way I have
it set up except for the last part "with one memo field". Not sure what that
means. Right now I have only a few records (interviewees) entered. There are
twenty or so memo fields that represent topics discussed in the interview.
The report I am trying to create is just a dump of the interview topic data
per interviewee. I hope to end up with a quick report for each interviewee
showing what was said. So far I have been able to create the report and it
looks fine but I run out of room on the report because my controls have to be
big enough to accept the text from the fields and the 22" limit won't let me
fit all of my controls on the report. I have tried creating sub-reports but
trying to format the sub-report to look seemless with the main has proven to
be problematic. Any ideas? Thanks for your time.

 

[Guest]

Thanks for getting back to me. For whatever reason when I pick the CanGrow it
doesn't work. My controls don't expand to accept the small paragraphs of
interview text. I am having trouble formatting the sub report to blend in
with the main report.Probably a stupid question but how do I add a section?
Is is another Detail section? Thanks for your time. Greg

 

[Duane Hookom]

I wouldn't work any more on a system that doesn't allow me to easily add
"topics". Take a look at the employee evaluation sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Rick Brandt]

Thanks for getting back to me. For whatever reason when I pick the
CanGrow it doesn't work. My controls don't expand to accept the small
paragraphs of interview text. I am having trouble formatting the sub
report to blend in with the main report.Probably a stupid question
but how do I add a section? Is is another Detail section? Thanks for
your time. Greg

Make sure the CanGrow of the report section is also enabled.