Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Nov 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform/sub report formatting (Access 2000)

    I am creating a report in which I have multiple subreports side by side. How can I have them right next to each other without a big gap between? It works when I put them underneath one another but not side by side. Any suggestions?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Subform/sub report formatting (Access 2000)

    I'm not sure why you get the gap.
    Is the subreport control on the main report wider than the actual report that is going in it?
    Regards
    John



  3. #3
    Lounger
    Join Date
    Nov 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform/sub report formatting (Access 2000)

    No. I reverted back to the subreport to be sure that it didn't have an overhang & it didn't.

    STUMPED...Kari P.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Subform/sub report formatting (Access 2000)

    Can you post a cut down version of the db to have a look at.
    I often put subreports side by side without problems so I don't know what the problem is.

    You can get problems with vertical spacing when you do this, because the different subreports can be of different lengths.
    Regards
    John



  5. #5
    Lounger
    Join Date
    Nov 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform/sub report formatting (Access 2000)

    What do you mean by a cut down verson of the db?

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Subform/sub report formatting (Access 2000)

    Your db is probably too big to post, and may contain stuff you don't want everyone to see.

    A cut down version would contain just an example of a report behaving the way you describe, ( and a couple of its subreports) , just the tables (and queries) needed for the report to work, and just the bare minimum of records.
    Regards
    John



Posting Permissions

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