Printing form with tab controls

ms1202

New Member
Joined
May 25, 2006
Messages
26
I have a form that is split into three pages by tab controls but when I click print it only prints the first page. How do I make it print all three pages?
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,304
Office Version
  1. 365
Platform
  1. Windows
Why do you want to print the form?

Forms aren't really meant for printing, you should use reports instead.
 

VicRauch

Well-known Member
Joined
Mar 23, 2006
Messages
2,032
Click Print while the first tab is selected. Then select the second tab, click print again, then select the 3rd tab and click on print one last time. But, then again, why would you want to print a form? I could see printing a form during development because I can't remember much any more, and a printout really helps me. But if it is for an operational thing, Norie has the correct responds, "You should us reports instead.
 

ms1202

New Member
Joined
May 25, 2006
Messages
26
Thanks, that's done the job. Access seems a lot harder to just pick up and teach to yourself than Excel! I guess I need to practice more!
 

VicRauch

Well-known Member
Joined
Mar 23, 2006
Messages
2,032
If you are new to Access, and therefore databases, please read this. To have a database work will, be able to use it effectively, and not always be fighting with it, you need to learn to normalize the data.
 

ms1202

New Member
Joined
May 25, 2006
Messages
26
Brilliant, thank you very much. I will have a look over the weekend.
 

Forum statistics

Threads
1,141,924
Messages
5,709,369
Members
421,632
Latest member
BrennieB

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top