Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print to Fit page (Access 2000)

    I have an Invoice report with three parts. The top part never changes in size. The middle section and the bottom section change according to the amount of information relative to that client. Is there a way to keep all three parts on one page? Basically, I need a print to fit page command. Quite often, the information forces the report to be 2 pages, when it could easily fit on one page. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print to Fit page (Access 2000)

    You can set the Can Shrink property of controls such as text boxes and of the section containing them to Yes (this does not apply to the page header and footer sections). If a control contains less information, the height of the control will be shrunk accordingly.

    If you mean that you want to scale the report by decreasing the font size to keep it on one page, there is no built-in way to do that, and writing code for it would be very complicated.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print to Fit page (Access 2000)

    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •