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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Why do you want to print the form?

Forms aren't really meant for printing, you should use reports instead.
 
Upvote 0
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.
 
Upvote 0
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!
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,214,593
Messages
6,120,435
Members
448,961
Latest member
nzskater

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
Back
Top