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

[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?

 

[Allen Browne]

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

 

[Brett Collings [429338]]

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

 

[Douglas J. Steele]

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>

 

[John Vinson]

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

So a space alien walks into a bar and says "Take me to your liter!"

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps