I'm designing a form that will be a questionnaire with 56 questions, but when
I reach 21" in the vertical it stops. Is that the max length for the form
and if so how do I get around it? Thanks.
22" (all sections) and you can't make it larger.
Two suggestions:
Quick getaround - use a Tab Control. You can put dozens (if you
insist!) of tab pages, a few questions on each, reusing the same
screen real estate.
Better solution: Normalize your database. It sounds like you have one
*field* per question in your table, so you need multiple textboxes and
multiple labels, one bound to each question... right?
A much better design uses three tables: Questionnaires, Questions, and
Answers. Each question is in one *record* - and there's no limit to
the number of records you can put into a table (well, a 2 GByte limit
on the entire database, but...)
See Duane Hookum's excellent "At Your Survey" database for a
worked-out example:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'
John W. Vinson[MVP]