Results 1 to 11 of 11

Scale to Print on One Page

  1. #1
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92

    Scale to Print on One Page

    Is there a way similar to in Excel where you can set the Print Setup to "Scale to Fit" say 1 wide by however many pages needed?

  2. #2
    llkhoutx is offline llkhoutx
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    340
    Shrink-to-fit using the "Page Setup" "Fit-to:" options.

  3. #3
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92
    i do not see that as an option on the Page Setup screen.

  4. #4
    llkhoutx is offline llkhoutx
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    340
    It's there. Try the PrintPreview f the report, then the PageSetup icon.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,907
    I do not see that option on my Page Setup form either. It may also be a feature of certain printer drivers.
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  6. #6
    llkhoutx is offline llkhoutx
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    340
    Sorry, IU was looking at Excel print preview.

    A solution would be to cycle through all the reports and subreport controls proportionally reducing them in (twips) size ((Desided page width *1440) / (Real form width in inches * 1440)). Control height should probably also be adjusted. Lines probably don't require adjustment.

    I'd try it on the report OnFormat that fires first; if that doesn't work try it on the design view of the report with a Class Module function.

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,907
    Quote Originally Posted by llkhoutx View Post
    Sorry, IU was looking at Excel print preview.

    A solution would be to cycle through all the reports and subreport controls proportionally reducing them in (twips) size ((Desided page width *1440) / (Real form width in inches * 1440)). Control height should probably also be adjusted. Lines probably don't require adjustment.

    I'd try it on the report OnFormat that fires first; if that doesn't work try it on the design view of the report with a Class Module function.
    That solution should keep the OP busy for a while.
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  8. #8
    llkhoutx is offline llkhoutx
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    340
    Rural Guy, I believe that you are incorrect. I've been around the block for a long, ling time. Modern CPUs never cease to amaze me.

    I programmatically modify controls and their respecttive properties all the time and have never experienced a performance hit while doing so.

    The compute time is insignificant.

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,907
    I believe I said "keep the OP busy", not the CPU.
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  10. #10
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92
    so is my only real option to just format the sheet so it fits on one page?

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,907
    Quote Originally Posted by diane802 View Post
    so is my only real option to just format the sheet so it fits on one page?
    I believe so Diane.
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Print Preview different from Print Hardcopy
    By peterc in forum Reports
    Replies: 4
    Last Post: 10-27-2009, 04:35 AM
  2. Error when trying to print or print preview
    By TriAdX in forum Reports
    Replies: 8
    Last Post: 08-25-2009, 07:20 AM
  3. Replies: 1
    Last Post: 03-12-2009, 08:55 AM
  4. Replies: 0
    Last Post: 02-11-2009, 04:43 PM
  5. code to print just first page of a report
    By tonyrice in forum Reports
    Replies: 1
    Last Post: 02-14-2007, 01: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
  •  
Tech Forums: Microsoft Office Forums