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

GBruehler wrote:
> 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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • How do you beat the 22" high report limitation in Access
    ... I am trying to create a report for a small database that was created for ... storing interview comments. ... The fields are all Memo and contain ...
    (microsoft.public.access.reports)
  • Re: select column name base on users choice
    ... definition at runtime so that its controls are bound to the selected columns. ... In fact you are going to have to amend the report definition anyway, ... But this will only store the query in a string, ...
    (microsoft.public.access.queries)
  • Re: Microsoft has utterly failed with Access 2007
    ... Access 2003 already included grouped controls. ... if I have a typical report with a line of details ... property sheet opening ... In other words again the keyboard choices and general design of access 2007 ...
    (microsoft.public.access.modulesdaovba)
  • Re: multiple subform images per main search form record
    ... Thanks for pointing me to the links to the tutorial and to the report code. ... I have added the textbox controls ImageID1 through ImageID5 on the main ... In the subform itself, you can process a double-click event on each ... enlarged image and filter it analgous to how you filter the popup form ...
    (microsoft.public.access.formscoding)
  • Re: Bug in Access 2002 Reports
    ... from within the Detail Section format event ... This will give the report a feeling of being "to scale", when you look at it you can see there are smaller, larger or equal intervals. ... Access will format the section but it will remember the last placement of the controls. ...
    (microsoft.public.access.reports)
Loading