Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Border (Access 2002, SP3)

    Is there a way to create a border around the edge of an Access report or does this have to be done in two steps. One print the border by itself on a blank page and two, print the report on the page containing the border.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

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

    Re: Report Border (Access 2002, SP3)

    You can use the On Page event of the report to draw a border. See for example Microsoft Access Report Formatting.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Border (Access 2002, SP3)

    Thanks, that will come in handy. The only problem I had was that the border across the bottom did not appear. I tried changing some of the settings and found how I could make a solid border and change its color but not how to make it appear at the bottom of the page. I even tried changing the margin for the bottom of the page but that did not help.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

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

    Re: Report Border (Access 2002, SP3)

    You could experiment by changing Me.ScaleHeight in the code to

    Me.ScaleHeight - 120

    or

    Me.ScaleHeight - 240

    to see if the bottom edge appears.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Border (Access 2002, SP3)

    Thanks. I tried that and it worked.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

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