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

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.

"Duane Hookom" wrote:

> 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.
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "GBruehler" <GBruehler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D123EF57-3E92-4D66-BC5A-EA8CC5CA5864@xxxxxxxxxxxxxxxx
> >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
>
>
>
.

Relevant Pages

  • Re: How do you beat the 22" high report limitation in Access
    ... > it set up except for the last part "with one memo field". ... > twenty or so memo fields that represent topics discussed in the interview. ... I hope to end up with a quick report for each interviewee ... > fit all of my controls on the report. ...
    (microsoft.public.access.reports)
  • Re: Truncating of memo fields
    ... Robin wrote: ... >The data is not being compared in the memo field although ... >the query in a list box. ... >to run this report with many records, ...
    (microsoft.public.access.reports)
  • Re: Media Disinformation
    ... Mads Gilbert, is a man with an extremist political past. ... Gilbert also used a BBC interview from Gaza's Shifa Hospital ... showing dead toddlers allegedly killed in the Gaza fighting. ... France 2, which apologized Monday for the erroneous report, was also the ...
    (soc.culture.jewish.moderated)
  • Re: Report issue
    ... The query now selects fields from 2 tables joined by a filed. ... The resulting list which contains the caption fields and memo field forms the ... code so that the report with one record will print as seperate printout. ... Below it the memo field ReportsMemo.crreport. ...
    (microsoft.public.access.modulesdaovba)
  • Media Disinformation
    ... Mads Gilbert, is a man with an extremist political past. ... Gilbert also used a BBC interview from Gaza's Shifa Hospital ... oppressed also have a moral right to attack the USA with any weapon they ... France 2, which apologized Monday for the erroneous report, was also the ...
    (soc.culture.jewish.moderated)