databasedev.co.uk - database solutions and downloads for microsoft access

Create Better MS Access Reports
Report Builder for Microsoft Access helps you create dynamic, professional-looking reports fast! The easy-to-understand wizard helps you with complex tasks like calculated fields, adding subreports, customizing styles, as well as grouping and sorting. Download a free trial today!

Microsoft Access Report Borders

Create a Border around a Microsoft Access Report Page

When creating reports in Microsoft Access there are certain formatting options that can be applied whilst in design view of the database report. You may wish to add Lines or Rectangles to frame specific areas of the report to ensure that these stand out amongst the other information.

There are also options available to create Borders around the entire page of an Access report, and using the simple code below will allow you to do this:

Since you want to modify the page, it makes sense to put this code in the Report_Page() event.

 Private Sub Report_Page()
    On Error Resume Next
        'Set Thickness and Border Style
         
        'Larger Number creates Thicker Line
        Me.DrawWidth = 1
        'Values 0 to 6 = Solid Line to Invisible
        Me.DrawStyle = 2

        'Object.Line (x1, y1) - (x2,y2), color, [Box=B]
        Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), vbRed, B
 End Sub

The code above creates the following effect:

Displaying a Border around your Microsoft Access Report
Displaying a Border around your Microsoft Access Report