G Guest Sep 8, 2006 #1 I am looking at creating a certificate that access can print as a report with the border already at the printer min settings.
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 Sep 8, 2006 #2 Hi, you might find this helpful: http://www.lebans.com/PrintLines.htm HTH Good luck
G Guest Sep 20, 2006 #3 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
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 Sep 20, 2006 #4 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
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
