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

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.

--
Duane Hookom
MS Access MVP
--

"GBruehler" <GBruehler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B2824BF0-0733-4FF1-9CFE-805D7C07E597@xxxxxxxxxxxxxxxx
> 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
    ... Duane, thanks for getting back to me. ... it set up except for the last part "with one memo field". ... The report I am trying to create is just a dump of the interview topic data ...
    (microsoft.public.access.reports)
  • Re: Continuous form - change size of entries
    ... > There is a memo field which has data that varies from 1 line to 30 lines. ... The user is happy with the report but not the form. ... or large in which case scroll bars appear. ... No. Controls on a Form do not have a Can Grow property in Form View ...
    (microsoft.public.access.forms)
  • 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)