• Horiz lines on a Report (AC2K)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Horiz lines on a Report (AC2K)

    Author
    Topic
    WSDevious Dude
    AskWoody Lounger
    October 14, 2002 at 8:35 pm #377963

    I have a report which lists Fees collected for classes I conduct at a local hall. I wish to print the report, and then print horizontal lines from the end of the data to the bottom of the page (suitably spaced), so I can hand record additional fees collected under the printed data, and use the report as an input document when I get home. I can produce the report no problems, but have been scratching my head on how to print horizontal lines to the end of the page.
    I just know there has to be a way.

    TIA

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSHankDaley
      AskWoody Lounger
      October 14, 2002 at 10:51 pm #624142

      On your tools toolbar there is abutton for drawing lines, just like on the draw toolbar in Word.

      Click on.

      Place cursor, drag out length of line in report design view.

      Reply | Quote
      • WSDevious Dude
        AskWoody Lounger
        October 14, 2002 at 11:14 pm #624150

        I know how to draw lines, but how do I fill to the end of the report with a NUMBER of lines

        Reply | Quote
    • WSpatt
      AskWoody Lounger
      October 14, 2002 at 11:26 pm #624154

      If you know how many lines are printed per page, you could:

      1. set up a table with a number of records (blank) that would complete the report.
      2. You would use a Union query to select the data for the report, sorting the extra records so they appear last in the report.
      3. You would have to add some code to the Detail section checking when a blank record is ready to be printed and set all the fields bar the underline to invisible and the line to visible (and vice versa for the normal line).

      I realise this is a complex solution, but I cannot think of an easier way at this time, maybe someone else will (I will stay tuned with interest).

      HTH
      Pat smile

      Reply | Quote
      • WSDevious Dude
        AskWoody Lounger
        October 15, 2002 at 12:24 am #624166

        Thanks Pat. I guess an easier solution is a Pencil and Ruler.

        As the number of lines will vary, depending on the number of records, I thought there may be a (number_of_lines_used) property and an (end of data) event or something, that I may be able to use.

        Oh well, as I am the only user…………. Tough!

        Reply | Quote
      • WSDevious Dude
        AskWoody Lounger
        October 15, 2002 at 12:34 am #624172

        Pat,

        Just had divine inspiration.

        What if I create a number (say about 10) horizontal lines (complete with labels for headings), in the REPORT FOOTER. This would add to the bottom of the report. If it goes over to a new page, so what! I would then always have about 10 lines to record new receipts, every time I reprinted the report.

        Hmmmm maybe simple solutiions in the long run are best!

        Reply | Quote
        • WSpatt
          AskWoody Lounger
          October 15, 2002 at 12:39 am #624173

          Why not, it sounds so much simpler !!
          Not elegant but simpler, your idea will probably take about 100th of the time to implement.

          Pat smile

          Reply | Quote
        • WScharlotte
          AskWoody Lounger
          October 15, 2002 at 4:19 am #624258

          Access reports have a Line method that you can use to draw lines on the report as well. So at the end of the report, you could automatically draw enough lines to fill the rest of the page.

          Reply | Quote
          • WSRichUK
            AskWoody Lounger
            October 15, 2002 at 11:19 am #624267

            Download the RptSmp97 from MS, look up how to print a constant number of lines
            Edited by WendellB to activate link 15-Oct–02 06:14 MDT (UTC-7)
            Also see the specific article here

            Reply | Quote
          • WSpatt
            AskWoody Lounger
            October 15, 2002 at 7:24 pm #624370

            The things you learn, well I’ll be.
            Thanks you guys, Charlotte and RichUK.
            Pat

            Reply | Quote
    Viewing 1 reply thread
    Reply To: Horiz lines on a Report (AC2K)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.