Is it possible to have a two page form and only print the first page or
second page when needed.?
Al Campagna - 28 Dec 2007 14:33 GMT
Depending on your design, you should be able to use the File/Print dialog
box
selection to print 1 of 2, or 2 of 2 pages.
But, forms are made for data entry, and viewing... not printing. Better
that you develop a rptPageOne and a rptPageTwo and select either for
printing from your form.

Signature
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
> Is it possible to have a two page form and only print the first page or
> second page when needed.?
Tom van Stiphout - 28 Dec 2007 14:35 GMT
Printing is best done using a report. You could create two reports,
one for each page.
-Tom.
>Is it possible to have a two page form and only print the first page or
>second page when needed.?
Jeff Boyce - 28 Dec 2007 15:03 GMT
I'm not clear what you mean by "a two page form"...
You've already received great advice about using reports, not forms, for
printed output.
If you are saying that the information you are displaying to your users
requires them to scroll from one page to another, consider using the tab
control. This gives you a way to "stack" pages and gives your users a way
to click on the tabs to see the different parts.
By the way, how is it that you have two pages worth of fields? What's the
underlying table look like? (hint: it all starts with the data...)
Regards
Jeff Boyce
Microsoft Office/Access MVP
> Is it possible to have a two page form and only print the first page or
> second page when needed.?