form length

S

sue gray

I have a form that is too long. Could someone please give me ideas on how to
break it up and still have it readable and printable. Thanks
 
A

Al Campagna

Sue,
Reports have a 22" length "design" limit. The actual print length is unlimited (within
reason)
Use subreports for related tables and fields , associated through some key unique main
report value. A 1/2" high subreport will expand to print as many records as it delivers,
yet only occupies "1/2" on the design.
--
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."
 
S

sue gray

Thanks for the response. Actually my current problem is with the form
design. I need to create a form that on paper is 6 pages long. What's the
best way to handle this? Thank you.
 
S

sue gray

I guess I don't understand subreports. I assumed subreports referred to
reports. I will do some checking into subreports. Thanks.
 
T

Tom Lake

sue gray said:
I guess I don't understand subreports. I assumed subreports referred to
reports. I will do some checking into subreports. Thanks.
Click to expand...

If you want to create a fillable, on-screen form, also check out
tabbed form pages. That'll let you divide your form into logical screen
displays.

Tom Lake
 
S

sue gray

That sounds like a good idea. How hard is it to put all the tabbed form pages
into one report? Thanks
 
A

Al Campagna

Sue,
Doh!!
I apologize... I just had in my mind that your question applied to a report... which is
where we most often see this type "too long" problem.
Totally my mistake...
Tom is right on with suggesting TabPages as the cure for "forms"
Good luck,
--
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."
 
S

sue gray

NO problem. I appreciate the help.

Al Campagna said:
Sue,
Doh!!
I apologize... I just had in my mind that your question applied to a report... which is
where we most often see this type "too long" problem.
Totally my mistake...
Tom is right on with suggesting TabPages as the cure for "forms"
Good luck,
--
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."
Click to expand...
 
Top