Results 1 to 13 of 13
  1. #1
    Charles CL is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Dec 2015
    Posts
    35

    Broken line object between detail section and page footer

    Dear All,

    I tried to join the line object between detail section and page footer, however it is not successful.



    Then, I tried to bring the border of each section as close as possible to my objects, however, the same result was appeared.

    Please advice how to do this.

    Attachment:
    Break Line Between Detail Section and Page Footer or Report Footer.pdf

    Thanks,
    Charles

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I had good luck doing this with the Report Footer. We may need to look at your db, if possible.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    This looks like a continuation of your previous post on the order of appearance for the report and page footers. Perhaps you should continue that one, since it looks like you have a bunch of #Error flags in your controls?

  4. #4
    Charles CL is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Dec 2015
    Posts
    35
    RuralGuy,

    Thanks for viewing and reply for this post.
    Please open the file in design view.

    Attachement:
    PRReport.zip

    Thanks,
    Charles

  5. #5
    Charles CL is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Dec 2015
    Posts
    35
    Micron,

    Yes. It is the same report. However, problem was solved by making some trick on it.

    The error was appeared because the control source for the particular text box was not from the tables or queries.
    I make it the control source from the form whereby the user has to enter/key in the data, but this data is not going to stored in my database.

    Please refer to the zip file i uploaded for your reference.
    Please advice for the problem.

    In the design view, the lines were connected but when i switch it to print preview, the line broken.
    Headache...

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Sorry Charles but without additional tables and forms the Report will not switch to Preview mode.

  7. #7
    Charles CL is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Dec 2015
    Posts
    35
    RuralGuy,

    I'm sorry that tables are confidential.

    Could you roughly advice that how to make the lines joined together?
    I draw the straight line using line object to connect the border line between detail section and page footer section.

    Perhaps apply some codes will do?

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    As I stated earlier, I've had success using the Report Footer where you are using the Page Footer. That is about the only advice I can give at this time. Sorry.

  9. #9
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Exactly what RuralGuy is saying. Have a look at this thread, very similar to yours: https://www.accessforums.net/access/...int-57072.html

  10. #10
    Charles CL is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Dec 2015
    Posts
    35
    Dear RuralGuy,

    The following is the template for the report i created, please have a look.
    At report view or layout view, the report's lines linked, but when switched to print preview, the lines break.

    I put the option buttons and those other information into the page footer because i need it to be repeated for every page of the report.
    For your information, the report is sometimes more than 1 page.

    Another thing is the [total] where i put it into the page footer too because i need it to sit at the bottom. However, i set some VBA code for it so that it will only appears at the last page of the report. Thats why i said i solved my problem at previous post.
    https://www.accessforums.net/reports...ter-57257.html

    I tried your method that i put it into report footer, however, it appears at the last page only. Unfortunately, i need it to be appeared at every page of my report for those information. Please refer to the attachment for those information in page footer.

    Attachment:
    ABC_Report_Template.zip

    Thanks,
    Charles

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Will take a look Charles. Thanks for the upload.

  12. #12
    Charles CL is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Dec 2015
    Posts
    35
    Hi RuralGuy,

    May i know any solution for that?

    Regards,
    Charles

  13. #13
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm afraid I've still not been able to resolve your issue. Sorry.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-05-2014, 03:56 PM
  2. Replies: 2
    Last Post: 01-09-2014, 07:24 PM
  3. Replies: 2
    Last Post: 12-21-2013, 02:09 PM
  4. Replies: 2
    Last Post: 10-15-2013, 09:30 AM
  5. Replies: 6
    Last Post: 03-26-2013, 12:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums