Access 97 report max length

  • Thread starter Thread starter barbara j
  • Start date Start date
B

barbara j

I'm building the most complex report I've done and have
run into a wall at 22". I can't find a max length
documented; can annyone out there confirm this or am I
doing something wrong? Thanks!
 
barbara said:
I'm building the most complex report I've done and have
run into a wall at 22". I can't find a max length
documented; can annyone out there confirm this or am I
doing something wrong?
Click to expand...


The design space height and width limit of each report
section is 22". The total design Height of all sections is
200". It's somewhere in Help, but under different topics in
different versions.

I doubt if that information is particlarly useful to you,
especially since I've rarely heard of anyone that couldn't
live within these restrictions. If you'll explain what
you're trying to do, I'm sure someone will be able to offer
an alternative approach that will get you going.
 
I have a main table that represents a field monitoring
site, and then 9 tables of related data. My report
consists of putting out all data pertaining to a site.

The main table fields (about 18) use 7" and the 9
subreports are about 1.75" each (each sub has 4 to 8
fields). Much of the data is descriptive (i.e. text boxes
the width of the report), so labels are needed as well as
horizontal lines between subreports.

Thanks for any alternative ideas!
 
barbara said:
I have a main table that represents a field monitoring
site, and then 9 tables of related data. My report
consists of putting out all data pertaining to a site.

The main table fields (about 18) use 7" and the 9
subreports are about 1.75" each (each sub has 4 to 8
fields). Much of the data is descriptive (i.e. text boxes
the width of the report), so labels are needed as well as
horizontal lines between subreports.
Click to expand...


That is a lot of data!!

The first thing to do when cramped for space is to make the
subreport controls shorter (say 1/2") and set their CanGrow
property to Yes so they can expand to take as much space as
required. If you do this, make sure the other control do
not overlap the subreport controls. If you have a bunch of
text boxes that consume an entire horizontal "row" in the
detail section, you could also reduce their height and set
them to Grow as well.

Another approach is to add a group level (View menu =
Sorting and Grouping) at the bottom of the grouping list
using the detail section's sort field. You can then add a
group header and footer section and spread the detail
controls out over three sections.
 
It probaly has to do with the max paper size your printer
can handle. Try a printer or plotter that can handle
larger with paper and see if that makes a difference. Set
the plotter/printer as defaults with a larger size paper.
Good luck
 
Back
Top