Results 1 to 8 of 8
  1. #1
    diegoah is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2014
    Posts
    4

    Print report with multiple Tabs


    Can i print a report with multiple tabs ?
    follow the exemple !Click image for larger version. 

Name:	Relatorio.jpg 
Views:	16 
Size:	13.8 KB 
ID:	15216
    Thanks !

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Report View and Print Preview are two different things in newer versions of Access. In report view you can have user interaction with controls, like the Tab Control. In print preview, you can not. I believe if you print a report the controls will not appear.

  3. #3
    diegoah is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2014
    Posts
    4
    Quote Originally Posted by ItsMe View Post
    Report View and Print Preview are two different things in newer versions of Access. In report view you can have user interaction with controls, like the Tab Control. In print preview, you can not. I believe if you print a report the controls will not appear.
    I dont want to print the control...i want to print the content of the muliple tabs..

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Then don't use the tab control in your report.

  5. #5
    diegoah is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2014
    Posts
    4
    Quote Originally Posted by ItsMe View Post
    Then don't use the tab control in your report.
    But each report has 5 tabs to print.
    It dosent fit if i put one bellow the other !

  6. #6
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    A report's maximum width/height is 22 inches, you should be able to fit 6 pages into that space, you just have to control the width/height of your data showing with a little finesse.

  7. #7
    diegoah is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2014
    Posts
    4
    Quote Originally Posted by rpeare View Post
    A report's maximum width/height is 22 inches, you should be able to fit 6 pages into that space, you just have to control the width/height of your data showing with a little finesse.
    The thing is that i need to print the data in 6 different pages which is bigger than 22 inches.

  8. #8
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    no it's not. If you are printing on 8.5 x 11 paper you can fit 6 pages on the 22x22 area
    (7.5 x 3 = 21.5 inches (width) which is 3 pages wide with a half inch margin)
    (10 x 2 = 20 inches (height) which is 2 pages vertically with a half inch margin)

    As I said you'd have to manage your data with a little finesse but 22x22 is plenty for 6 pages worth of information.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-16-2013, 07:43 PM
  2. Replies: 1
    Last Post: 03-16-2013, 09:20 PM
  3. Replies: 12
    Last Post: 12-17-2012, 12:47 PM
  4. Replies: 2
    Last Post: 02-08-2012, 01:03 PM
  5. export report to multiple tabs
    By mws5872 in forum Import/Export Data
    Replies: 0
    Last Post: 06-30-2009, 03:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums