Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Empty second page in Report

Discussion in 'Information Technology' started by Stuart Grant, Nov 6, 2005.

  1. Stuart Grant

    Stuart Grant
    Expand Collapse
    Guest

    I'm working on my first project in Access 2003 (although I have a very
    little experience with earlier versions). Going reasonably well. I have two
    queries working well and am setting up a report for one of them. Only
    problem - the report only takes one page but I always get in Print Preview
    or Layout view a second page with nothing on it but the page headers. Why?
    Stuart
     
  2. Loading...

    Similar Threads Forum Date
    Elijah's Empty Chair of Freedom in Oslo Interfaith Dialogues Dec 13, 2010
    Journeying Inward: The beauty of the empty vessel Spiritual Articles Nov 29, 2010
    Sikh News Second Annual Sikh Youth Leadership Institute Held In Ottawa Breaking News Aug 18, 2016
    Malaysia Second Malaysian Plane Lost in only 4 months! Breaking News Jul 18, 2014
    USA The Second Annual Conference on Sri Guru Granth Sahib Breaking News Oct 30, 2013

  3. Allan Murphy

    Allan Murphy
    Expand Collapse
    Guest

    You may have a page break some where is your grouping footer or after your
    detail section

    --
    Allan Murphy
    Email: allanmurphy@unwired.com.au
    "Stuart Grant" <sagrantatbluewindotch> wrote in message
    news:436c9022_3@news.bluewin.ch...
    > I'm working on my first project in Access 2003 (although I have a very
    > little experience with earlier versions). Going reasonably well. I have

    two
    > queries working well and am setting up a report for one of them. Only
    > problem - the report only takes one page but I always get in Print Preview
    > or Layout view a second page with nothing on it but the page headers. Why?
    > Stuart
    >
    >
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Stuart Grant wrote:
    > I'm working on my first project in Access 2003 (although I have a very
    > little experience with earlier versions). Going reasonably well. I
    > have two queries working well and am setting up a report for one of
    > them. Only problem - the report only takes one page but I always get
    > in Print Preview or Layout view a second page with nothing on it but
    > the page headers. Why? Stuart


    In addition to Allen's suggestion I suggest you look carefully at the
    right margin. In anything goes over the margin, it will cause a nearly
    blank page to be created. That blank page may have only one pixel on it.
    Horizontal lines or boxes are the usual problems.

    --
    Joseph Meehan

    Dia duit
     
  5. Allan Murphy

    Allan Murphy
    Expand Collapse
    Guest

    Joseph

    The incorrect margins or page setup would give you a blank page, which could
    range from a total blank page to a page which has lines and some of the
    header and footers etc.

    But Stuart said that he had page headers, so I am assuming all the page
    header is there

    --
    Allan Murphy
    Email: allanmurphy@unwired.com.au
    "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    news:qc2bf.85073$Hs.72257@tornado.ohiordc.rr.com...
    > Stuart Grant wrote:
    > > I'm working on my first project in Access 2003 (although I have a very
    > > little experience with earlier versions). Going reasonably well. I
    > > have two queries working well and am setting up a report for one of
    > > them. Only problem - the report only takes one page but I always get
    > > in Print Preview or Layout view a second page with nothing on it but
    > > the page headers. Why? Stuart

    >
    > In addition to Allen's suggestion I suggest you look carefully at the
    > right margin. In anything goes over the margin, it will cause a nearly
    > blank page to be created. That blank page may have only one pixel on it.
    > Horizontal lines or boxes are the usual problems.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
     
  6. Stuart Grant

    Stuart Grant
    Expand Collapse
    Guest

    Allan and Joseph
    Thank you both very much from your prompt and helpful suggestions. It must
    have been a page break in the report footer although I could not see it in
    design view. The report has no report footer but I think in playing around
    with it I may have put one in, taken it out and left a blank space with a
    page break. Anyway I changed the properties of the report footer to Not
    Visible and the problem has disappeared.
    Incidentally, Joseph, I did earlier have this problem because of the right
    margin but I managed to figure that out.
    I don't like to bother you fellows too much but could either of you tell me
    how to put in a nice thick line after the heading parallel to the grid.
    There was one in the automatic Access version but I took it out because of
    the right margin problem. When I try to put one in using the line tool in
    the Toolbox, my shaky hand makes it not parallel or I get two lines the
    wrong width. There must be an easier way.
    Stuart
     
  7. Allan Murphy

    Allan Murphy
    Expand Collapse
    Guest

    Stuart

    The trick is to hold the shift key down then select the line tool, KEEP
    HOLDING THE SHIFT KEY DOWN and place the start of the line where you want to
    start your line then draw the line the required distance, hopefully you will
    have a nice straight line. If you do not hold the shift key down the line
    could become crooked.

    The thickness of your line can be set by using the border width property of
    the line, the default value is Hairline if you set it at 2pt you will get a
    thick line.

    --
    Allan Murphy
    Email: allanmurphy@unwired.com.au

    "Stuart Grant" <sagrantatbluewindotch> wrote in message
    news:436dc8f5_3@news.bluewin.ch...
    > Allan and Joseph
    > Thank you both very much from your prompt and helpful suggestions. It

    must
    > have been a page break in the report footer although I could not see it in
    > design view. The report has no report footer but I think in playing

    around
    > with it I may have put one in, taken it out and left a blank space with a
    > page break. Anyway I changed the properties of the report footer to Not
    > Visible and the problem has disappeared.
    > Incidentally, Joseph, I did earlier have this problem because of the

    right
    > margin but I managed to figure that out.
    > I don't like to bother you fellows too much but could either of you tell

    me
    > how to put in a nice thick line after the heading parallel to the grid.
    > There was one in the automatic Access version but I took it out because of
    > the right margin problem. When I try to put one in using the line tool in
    > the Toolbox, my shaky hand makes it not parallel or I get two lines the
    > wrong width. There must be an easier way.
    > Stuart
    >
    >
     
  8. Stuart Grant

    Stuart Grant
    Expand Collapse
    Guest

    Re: Drawing a straight Line

    Allan
    Thank you very much for the guidance. My first effort had thin and thick
    parts but I have got the idea and will persevere.
    Stuart

    Allan Murphy wrote
    >The trick is to hold the shift key down then select the line tool, KEEP
    >HOLDING THE SHIFT KEY DOWN and place the start of the line where you want
    >to
    >start your line then draw the line the required distance, hopefully you
    >will
    >have a nice straight line. If you do not hold the shift key down the line
    >could become crooked.


    >The thickness of your line can be set by using the border width property of
    >the line, the default value is Hairline if you set it at 2pt you will get a
    >thick line.


    >Allan Murphy
    >Email: allanmurphy@unwired.com.au
     

Share This Page