Help! How can I print all tabs of a form?

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

Guest

I have a 3 page form. Because Access only allows 22" in length, I put each
page on a tab. I need to print tab1, tab2, tab3 all at once, before going to
the next record. How can I print multi-tabbed forms?

If that can't be done, what is the correct way to design a long (3-5 page)
form?

NB
 
You should print reports, not forms. Reports can go hundreds of pages, and
can be formatted to look much nicer than forms.
 
You don't PRINT forms. You print reports.

Build a report that is formatted to properly fit on the page the way you'd
like.

Forms are designed for viewing, adding, and changing data. Reports are
designed to print data.
 
If that can't be done, what is the correct way to design a long (3-5 page)
form?
Click to expand...

If you want to print the data, use a Report. Forms are designed for
onscreen viewing and editing (tab pages let you share screen space);
they're not optimized for printing. Reports are.

John W. Vinson[MVP]
 
Susan,
I have the same problem in reports - it can print hundreds of pages of
records, but the layout will only allow 22" in the detail section. My fields
take up 3 pages, because I have to give enough space for the reviewers to
hand-write comments in each section.

The purpose of this form (or report) is for Site Reviewers to take them to
review a site against criteria. The top portion must pre-populate with the
site data (name, address, etc.). The rest are fields with blanks and comment
sections for the reviewers to fill out (by hand) as they walk the site.

I can create the form for inputting the hand-written data into the dbase -
that isn't a problem, but the "pre-populated" form to give to the reviewers
is 3 pages long. Your thoughts?
 
Ah, now I see your problem - I had a similar one for field techs.
The solution I used was to create a Word Merge Document to print - Word will
let you do whatever it is you need to do.

Open the table or Query the form is based on, go to tools>Office Links>
Merge it with MS Word. Select the fields from the left side dropdown,
inserting whatever text you want for the labels, add blank lines (or
underlined spaces if you like) for the fill-in sections, page breaks,
company logo, images, whatever. Save it someplace. Then click on Merge, and
select new document, and you should be good to go!
 
John,
I have the same problem in reports - it can print hundreds of pages of
records, but the layout will only allow 22" in the detail section. My fields
take up 3 pages, because I have to give enough space for the reviewers to
hand-write comments in each section.

The purpose of this form (or report) is for Site Reviewers to take them to
review a site against criteria. The top portion must pre-populate with the
site data (name, address, etc.). The rest are fields with blanks and comment
sections for the reviewers to fill out (by hand) as they walk the site.

I can create the form for inputting the hand-written data into the dbase -
that isn't a problem, but the "pre-populated" form to give to the reviewers
is 3 pages long. Your thoughts?
NB
 
NB said:
John,
I have the same problem in reports - it can print hundreds of pages of
records, but the layout will only allow 22" in the detail section. My
fields take up 3 pages, because I have to give enough space for the
reviewers to hand-write comments in each section.

The purpose of this form (or report) is for Site Reviewers to take
them to review a site against criteria. The top portion must
pre-populate with the site data (name, address, etc.). The rest are
fields with blanks and comment sections for the reviewers to fill out
(by hand) as they walk the site.

I can create the form for inputting the hand-written data into the
dbase - that isn't a problem, but the "pre-populated" form to give to
the reviewers is 3 pages long. Your thoughts?
NB
Click to expand...

TestBoxes on reports that have lots of data in them can be made one line
tall and then have CanGrow set to yes. The fact that your report will have
large fields does not mean that you have to account for all of that space in
design view. You can also add additional Grouping Sections
(headers/footers). The 22 inch limit is per section, not per report.
 
Thank you Susan. This will work. I was hoping to keep it all within Access
for simplicity's sake.

Sometimes I am amazed at the simple issues that a robust program like Access
can't handle, e.g. giving more than 22" layout space, or giving the option of
printing tab controls in order!

The tabs would be a perfect solution for either forms or reports - but if
you can't print them as a group, they are far less useful than they could be!
Just venting.

I appreciate your help. Have a great day.
NB
 
Well, it *uses* Word, but at least you can do it all from within Access, if
that's any consolation.

;-)

Glad to help any time, good luck!

SusanV
 
Thank you, Rick.
NB

Rick Brandt said:
TestBoxes on reports that have lots of data in them can be made one line
tall and then have CanGrow set to yes. The fact that your report will have
large fields does not mean that you have to account for all of that space in
design view. You can also add additional Grouping Sections
(headers/footers). The 22 inch limit is per section, not per report.
Click to expand...
 
Back
Top