How do I put a border on an ACCESS report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking at creating a certificate that access can print as a report with
the border already at the printer min settings.
 
Tried but these are not quite what I want which is a simple solution of
border around entire report including report and page header/footers
 
Here's something I posted a while back in response to a similar question ...

You can do it with some code in the Page event procedure of the report ...

Private Sub Report_Page()

Dim sngTop As Single, sngLeft As Single
Dim sngWidth As Single, sngHeight As Single

Me.ScaleMode = 3
sngTop = Me.ScaleTop + 5
sngLeft = Me.ScaleLeft + 5
sngWidth = Me.ScaleWidth - 10
sngHeight = Me.ScaleHeight - 10

Me.Line (sngTop, sngLeft)-(sngWidth, sngHeight), vbBlack, B

'See Line Method in the help files for more information.

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 Report border query 0
Bordering for Report 5
How to create a report border that changes color w/each new secti 1
How to expand Report Border? 1
remove border around subreport 1
Excel Borders not printing in Excel 8
Import Word Doc Into Access Report 1
Access Report --> PDF Borders etc. not transferring 1

Back
Top