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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,353
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,176,227
Messages
5,902,037
Members
434,935
Latest member
jayrock1987

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