• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • 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 MVP, Access and Data Platform)Commented:
Not inherently ... but check here:

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

mx

0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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