Is there a way around 22" height limit for design section?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on designing an Access data entry form and I am running into a
limitation that is causing me problems. According to access specifications
in the help feature, these are form maximums:

Section height
22 in. (55.87 cm)

Height of all sections plus section headers (in Design view)
200 in. (508 cm)

I need the detail section to be be MORE than 22 inches long- more like 44!!!
I don’t want to start dumping stuff in the header/footer sections because
then it repeats on every page. Is there any way to set up a second detail
section or otherwise get around the 22 in section height problem?
 
No. Access measures everything in twips, where 1440 twips = 1 inch.
If you multiply 22 3/4 inches by 1440, you will get a good hint at the
nature of the limit.

Alternatives are to use multiple sections in your form, or use a tab control
with data on different pages.

In general, though anything that needs that kind of height is not a
correctly normalized database. If this is just for display, use a report
with lots of sections. If it is for data input, then run the table analyzer
for suggestions on how to improve your design:
Tools | Analyze | Table
 
No. Access measures everything in twips, where 1440 twips = 1 inch.
If you multiply 22 3/4 inches by 1440, you will get a good hint at the
nature of the limit.


Hi Beth

There's 567 twips in a centimeter if you're metric

Brett
Cheers,
Brett
 
Brett Collings said:
Hi Beth

There's 567 twips in a centimeter if you're metric

Actually, there's 567 twips to the centimeter even if you're not metric. <g>
 
Back
Top