Possible to select / define printable area in access report?

Discussion in 'Microsoft Access Reports' started by Mikael Lindqvist, Sep 16, 2009.

  1. Hi everyone,

    I have created a nice looking report but it doesn't fit on 1 page width
    (landscape orientation)... and there's no way I can make it smaller since
    some of the columns on the right contain text comments...

    Now, these columns (text comments) aren't necessary to print, but how do I
    "force" Access to ONLY print what's inside the 1 page width and neglect
    everything that's outside of that border?

    Kindly,
    Mikael
    Sweden
     
    Mikael Lindqvist, Sep 16, 2009
    #1
    1. Advertisements

  2. Mikael Lindqvist

    Duane Hookom Guest

    Have you tried designing your report to not exceed the right margin? You can
    set controls to allow (or not) vertical growing.
    --
    Duane Hookom
    Microsoft Access MVP


    "Mikael Lindqvist" wrote:

    > Hi everyone,
    >
    > I have created a nice looking report but it doesn't fit on 1 page width
    > (landscape orientation)... and there's no way I can make it smaller since
    > some of the columns on the right contain text comments...
    >
    > Now, these columns (text comments) aren't necessary to print, but how do I
    > "force" Access to ONLY print what's inside the 1 page width and neglect
    > everything that's outside of that border?
    >
    > Kindly,
    > Mikael
    > Sweden
     
    Duane Hookom, Sep 16, 2009
    #2
    1. Advertisements

  3. Hi and thanks for your promt reply and suggestion!

    I have tried to fit everything within 1 page width but my reports is a
    profit & loss account with 12 columns (for periods) plus a growing number of
    columns with comments (1 column per month contains comments). So I would have
    to make it really small and unreadable to achieve that.

    Everything is built around a crosstab query.

    As far as I can get my head around this the "best" solution would be if I
    could:

    a) Force the width to fit on 1 page (like you can do in excel)

    b) Define "printable area" (leaving out the comment columns)

    Right now, the only solution I can come up with is only print odd number
    pages (even number pages contain comments). Also, I tried tagging the comment
    columns "only visible on screen", but that doesn't stop the "emtpy" page from
    appearing when I try to print the report).

    Kindly,
    Mikael

    "Duane Hookom" wrote:

    > Have you tried designing your report to not exceed the right margin? You can
    > set controls to allow (or not) vertical growing.
    > --
    > Duane Hookom
    > Microsoft Access MVP
    >
    >
    > "Mikael Lindqvist" wrote:
    >
    > > Hi everyone,
    > >
    > > I have created a nice looking report but it doesn't fit on 1 page width
    > > (landscape orientation)... and there's no way I can make it smaller since
    > > some of the columns on the right contain text comments...
    > >
    > > Now, these columns (text comments) aren't necessary to print, but how do I
    > > "force" Access to ONLY print what's inside the 1 page width and neglect
    > > everything that's outside of that border?
    > >
    > > Kindly,
    > > Mikael
    > > Sweden
     
    Mikael Lindqvist, Sep 17, 2009
    #3
  4. Mikael Lindqvist

    Duane Hookom Guest

    Another option might be to export your query to Excel and formatting for
    print there.

    --
    Duane Hookom
    Microsoft Access MVP


    "Mikael Lindqvist" wrote:

    > Hi and thanks for your promt reply and suggestion!
    >
    > I have tried to fit everything within 1 page width but my reports is a
    > profit & loss account with 12 columns (for periods) plus a growing number of
    > columns with comments (1 column per month contains comments). So I would have
    > to make it really small and unreadable to achieve that.
    >
    > Everything is built around a crosstab query.
    >
    > As far as I can get my head around this the "best" solution would be if I
    > could:
    >
    > a) Force the width to fit on 1 page (like you can do in excel)
    >
    > b) Define "printable area" (leaving out the comment columns)
    >
    > Right now, the only solution I can come up with is only print odd number
    > pages (even number pages contain comments). Also, I tried tagging the comment
    > columns "only visible on screen", but that doesn't stop the "emtpy" page from
    > appearing when I try to print the report).
    >
    > Kindly,
    > Mikael
    >
    > "Duane Hookom" wrote:
    >
    > > Have you tried designing your report to not exceed the right margin? You can
    > > set controls to allow (or not) vertical growing.
    > > --
    > > Duane Hookom
    > > Microsoft Access MVP
    > >
    > >
    > > "Mikael Lindqvist" wrote:
    > >
    > > > Hi everyone,
    > > >
    > > > I have created a nice looking report but it doesn't fit on 1 page width
    > > > (landscape orientation)... and there's no way I can make it smaller since
    > > > some of the columns on the right contain text comments...
    > > >
    > > > Now, these columns (text comments) aren't necessary to print, but how do I
    > > > "force" Access to ONLY print what's inside the 1 page width and neglect
    > > > everything that's outside of that border?
    > > >
    > > > Kindly,
    > > > Mikael
    > > > Sweden
     
    Duane Hookom, Sep 17, 2009
    #4
  5. Yes, but I'm using a dynamic report from crosstab query with everything quite
    nicely formated in groups etc... it would be REALLY cumbersome to achieve
    something similar in Excel (and I'm a fairly experienced Excel-user).

    Access reports simply kick ass, but they are not perfect of course :p

    (For example, I really wish it would be possible / easy to make values in
    the report "clickable" so a user can drill down by clicking in the report)

    /Mikael

    "Duane Hookom" wrote:

    > Another option might be to export your query to Excel and formatting for
    > print there.
    >
    > --
    > Duane Hookom
    > Microsoft Access MVP
    >
    >
    > "Mikael Lindqvist" wrote:
    >
    > > Hi and thanks for your promt reply and suggestion!
    > >
    > > I have tried to fit everything within 1 page width but my reports is a
    > > profit & loss account with 12 columns (for periods) plus a growing number of
    > > columns with comments (1 column per month contains comments). So I would have
    > > to make it really small and unreadable to achieve that.
    > >
    > > Everything is built around a crosstab query.
    > >
    > > As far as I can get my head around this the "best" solution would be if I
    > > could:
    > >
    > > a) Force the width to fit on 1 page (like you can do in excel)
    > >
    > > b) Define "printable area" (leaving out the comment columns)
    > >
    > > Right now, the only solution I can come up with is only print odd number
    > > pages (even number pages contain comments). Also, I tried tagging the comment
    > > columns "only visible on screen", but that doesn't stop the "emtpy" page from
    > > appearing when I try to print the report).
    > >
    > > Kindly,
    > > Mikael
    > >
    > > "Duane Hookom" wrote:
    > >
    > > > Have you tried designing your report to not exceed the right margin? You can
    > > > set controls to allow (or not) vertical growing.
    > > > --
    > > > Duane Hookom
    > > > Microsoft Access MVP
    > > >
    > > >
    > > > "Mikael Lindqvist" wrote:
    > > >
    > > > > Hi everyone,
    > > > >
    > > > > I have created a nice looking report but it doesn't fit on 1 page width
    > > > > (landscape orientation)... and there's no way I can make it smaller since
    > > > > some of the columns on the right contain text comments...
    > > > >
    > > > > Now, these columns (text comments) aren't necessary to print, but how do I
    > > > > "force" Access to ONLY print what's inside the 1 page width and neglect
    > > > > everything that's outside of that border?
    > > > >
    > > > > Kindly,
    > > > > Mikael
    > > > > Sweden
     
    Mikael Lindqvist, Sep 17, 2009
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John Floyd

    Printer margins, printable area width

    John Floyd, Feb 6, 2004, in forum: Microsoft Access Reports
    Replies:
    3
    Views:
    1,400
  2. Casey

    Make Access Report Printable From Web

    Casey, May 22, 2004, in forum: Microsoft Access Reports
    Replies:
    2
    Views:
    178
    Mark Andrews
    May 24, 2004
  3. Nuno Almeida
    Replies:
    0
    Views:
    255
    Nuno Almeida
    Sep 15, 2004
  4. Karen Middleton

    Please help can't define a Access report for a query with 29 fields

    Karen Middleton, Dec 13, 2004, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    171
    Rick Brandt
    Dec 13, 2004
  5. Jay Chan
    Replies:
    3
    Views:
    814
    Jay Chan
    Aug 10, 2009
Loading...

Share This Page