Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Problem (2002)

    I have a report, rptSalesInvoice. There are two subforms on it. In the Page Section There is Sales Invoice Logo. and misc controls-fields. company name etc.
    In the detail section there is a subform SalesInvoicesLineItems.
    Record Source tblSalesInvoices.
    The main form is Jobcost and there is a Sales Invoice Template form with a button Print.
    This his hooked up to a macro Open rptSalesInvoice, PrintOut Hidden view Window.
    Here are the problems on print out it prints the sales invoice and a blank page.
    AND it prints out JobCost Form!
    Frank

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Problem (2002)

    Frank, does the report generate an extra page when running without using the macro? If so, have you checked your margins? Many times a report will exceed the page margin by a fraction of an inch and cause an extra page at the end. You can find the page margin under File | Page Setup (in Report Design view).

    If the report is fine alone and only generates an extra page when used in conjunction with a macro, then I'm out of ideas for the moment... <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Problem (2002)

    Seems like its coming from the two subforms.
    Don't know why this is so as all the info should fit on one page.
    Switched over to using a form temporarily.
    Frank

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Problem (2002)

    Are you printing from a report or from a form? If report, did you mean subREPORTS rather than subforms? This makes a big difference.

    If you have subreports in your report you'll want to double-check the "Can Grow" and "Can Shrink" properties. Depending on the data you're displaying with it, the subreport could be growing just enough to cause an extra page in your report. If you're only displaying a fixed amount of information with the subreport you can set CanGrow to "no". However, if you're displaying a variable amound of into you'll need to be prepared for the possibility that the length of the subreport could drastically change the layout of your report.

    Hope this helps

Posting Permissions

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