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?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,918
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,735
Members
410,703
Latest member
yaronjoseph
Top