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

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: Access: Memo Fields Being Cutoff When Exporting Reports into R
    ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... the most reliable way of exporting memo fields is to export from a table ... Is there a way that the query that is used for the report, ... Does anyone know of a reliable method of exporting memo ...
    (microsoft.public.access.externaldata)
  • RE: Is this a known issue?
    ... my problem is with a report within Access - it's ... 97 - memo fields for discussions, comments and replies), ... The bound textbox would only display the ...
    (microsoft.public.access.reports)
  • RE: Regarding conversion
    ... The data in the Access memo fields appeared to be truncated. ... add a text box to the form or report first and then set its ControlSource ... If carriage returns/line feeds had been included in the dBASE memo ... fields these appeared as a high ASCII character in Access (I don't recall ...
    (microsoft.public.access.gettingstarted)
  • Re: Query is not reflecting all records.
    ... "My objective is to create a report based on a query that includes the ... The General Information and Activity fields are memo fields. ... article excerpts in these fields, most excerpts are lengthier than 255 ...
    (microsoft.public.access.queries)
  • Re: Access Rich Text Memo Output to Word.rtf and PDF
    ... I'm using rtf memo fields - in an access report. ... Without border exported to PDF: ...
    (microsoft.public.access.reports)