How do I put a border on an ACCESS report

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.
 
G

Guest

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
 
B

Brendan Reynolds

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

How to create a report border that changes color w/each new secti 1
How to expand Report Border? 1
Change the color of only one side of a border 1
Possible to select / define printable area in access report? 4
how do i put a border round a report i created in design veiw? 3
Strange border when printing a form 3
ADDING COMPANY LOGO to A REPORT 2
Is this a bug? 1

Top