Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    One per Page (Office 97)

    Hi

    I have created a report from a query but it shows more than one record per page I would like to show just one record per page.
    can anyone help please.

    Thanks in advance

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: One per Page (Office 97)

    Brad

    In your report design view, extend the Headers and Footers until you get to the correct size.
    You'll have to play with them and preview until the size is correct.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: One per Page (Office 97)

    Hi Dave

    Thanks for that.

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: One per Page (Office 97)

    A much better way of achieving the one record per page is to set the Force New Page property of the Details section to 'after section'. (see attachment)
    Attached Images Attached Images
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: One per Page (Office 97)

    Thanks Steve.

    We learn something new every day <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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