Network,
There is no set answer for that... there is no property that determines how many
records can fit between any header or footer.
First that depends on the size of the header and footer. For max records don't use any
at all.
Given your screen resolution (the higher the better) it's really a matter of font size,
and control sizes. The smaller the font, and the smaller the control the more one-line
records you can display on one screen. Given your smallest font, that would be your
max... but readability is also a critical issue.
Also, the form allows for 22" of records, but as a general rule, you should avoid forms
longer than one screen.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions
"Find a job that you love, and you'll never work a day in your life."