Results 1 to 14 of 14
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Subform/Report (2003)

    I've been asked to create a form that will eventually be printed out as a report. There are a few of the sections on the report which will be tables. To achieve this I intend creating subforms. What I want to know is, when the report is printed, can I make the information from the main report, print directly under the sub-report, whether it contains 10 lines or 2. I think what they want to achieve is no empty 'white space'. Hope I am making sense.

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

    Re: Subform/Report (2003)

    Sections in a form / report and controls on a form / report (including subforms / subreports) have properties Can Grow and Can Shrink. if you set these to Yes, the elements will expand and contract as needed in the vertical direction.
    For forms, these properties are only effective when the form is printed or print previewed, not when the form is opened on screen.

    Note: I would always design a separate report; a form that looks good on screen will usually not look very good when printed, and a form optimized for printing will usually not look very good on the screen.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Subform/Report (2003)

    Ridiculously large picture reduced in size by HansV

    What I'm trying to do is something like the attatched image. As you can see there are 6 pages. For each page, I've created seperate tables, but I'm not sure if that's what I should have done. I thought using tabs, I could put each table on a seperate page, but I think all the fields should be on one table. Any suggestions/advice would be welcome. Also, on the pages, the information typed in could be blanked out by a sort of stamp, as in the image, but with the technique information filled in. Is something like this possible in Access.

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

    Re: Subform/Report (2003)

    Tab controls are an excellent tool for organizing a large number of controls on screen, but they are not suitable for printing - only the active tab page will be printed.

    It's not clear in your picture what is the main report and what is the subreport.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Subform/Report (2003)

    Thats the problem I've got. The ones begining with 'Tool Strip' will have to be subforms, because they can grow or shrink. Every page is like this. I'm only using access because of it's ability to do this.

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

    Re: Subform/Report (2003)

    Text boxes can also grow and shrink. However, neither subreports nor text boxes will do so if you put something on top of them, such as the "stamp" in your picture.

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Subform/Report (2003)

    If the 'stamp' is used, they won't need to. Apologies for the large image.

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

    Re: Subform/Report (2003)

    Creating the report with text boxes that can shrink and grow shouldn't be too hard, but I don't see how to superimpose the "stamp" on every page. Would it be ok just to have it on the first page?

  9. #9
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Subform/Report (2003)

    I think, initially it would be ok. We'll get round it somehow

  10. #10
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Subform/Report (2003)

    Having it on the first page would be ok.

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

    Re: Subform/Report (2003)

    Ok, you can use the Can Grow and Can Shrink properties of text boxes and of report sections to make the parts fit to their contents.

  12. #12
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Subform/Report (2003)

    Thanks Hans. Sorry I haven't replied before, but I've been on holiday. Any ideas on the 'stamp' I mentioned.

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

    Re: Subform/Report (2003)

    You can put a non-transparent rectangle or group box on top of the controls you want to hide partially, and put some controls on top of the rectangle.

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

    Re: Subform/Report (2003)

    Discussion has continued in <post:=579,060>post 579,060</post:>. This thread is locked to avoid duplication.

Posting Permissions

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