• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

Place a border report page

I am building a report and I will like to place a border around the entire report.

My problem is that when I the detail section only takes up a portion of the page I have a gap between the detail section and the footer section.

Is there a way to just place an entire border around a report page?
0
lashler2
Asked:
lashler2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not inherently ... but check here:

http://www.lebans.com/Report.htm

mx

0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  Use the OnPage event to draw a border around a page.  Would look something like this:

Private Sub Report_Page()

Me.DrawStyle = 0
Me.DrawWidth = 11

' Draw a border around the page.
Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), , B

End Sub



JimD.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now