How to draw page border in report.

[deepaksharma]

I have prepared a report which has page header and page footer and also report header and report footer. I want the page border to be printed on each page in the report but I am not able to understand how this page border will be drawn. I googled a lot about this but can't understand.

[CJ_London]

See this link
https://learn.microsoft.com/en-us/of...ss.Report.Line

and Google ‘access vba report line’ for more links

[deepaksharma]

See this link
https://learn.microsoft.com/en-us/of...ss.Report.Line

and Google ‘access vba report line’ for more links

it requires coding?

[Micron]

You can spend an hour getting vertical and horizontal lines in the report sections to line up and be the right lengths, or it can be as simple as one line of code in the sub:

Private Sub Report_Page()
   Me.Line (0,0)-(Me.ScaleWidth - 40, Me.ScaleHeight),, B
End Sub

You can play with the 40 value to get the right side looking the way you want it. Without subtracting some number, the line will probably be hidden by the page margin, so it depends on your margin settings. If you want colour in the line then add that as shown in the example.

[deepaksharma]

You can spend an hour getting vertical and horizontal lines in the report sections to line up and be the right lengths, or it can be as simple as one line of code in the sub:

Private Sub Report_Page()
   Me.Line (0,0)-(Me.ScaleWidth - 40, Me.ScaleHeight),, B
End Sub

You can play with the 40 value to get the right side looking the way you want it. Without subtracting some number, the line will probably be hidden by the page margin, so it depends on your margin settings. If you want colour in the line then add that as shown in the example.

thnaks... it work

[deepaksharma]

You can spend an hour getting vertical and horizontal lines in the report sections to line up and be the right lengths, or it can be as simple as one line of code in the sub:

Private Sub Report_Page()
   Me.Line (0,0)-(Me.ScaleWidth - 40, Me.ScaleHeight),, B
End Sub

You can play with the 40 value to get the right side looking the way you want it. Without subtracting some number, the line will probably be hidden by the page margin, so it depends on your margin settings. If you want colour in the line then add that as shown in the example.

how can i increase the thickness of the line in this code. i tried many things and even googled but failed every time.
like this
Me.Line (1,1)-(Me.ScaleWidth - 40, Me.ScaleHeight),, B

and

Me.Line (0,0)-(Me.ScaleWidth - 80, Me.ScaleHeight),, B

[Minty]

Your google skills appear to need a little training.

https://learn.microsoft.com/en-us/of...ne.borderwidth
https://learn.microsoft.com/en-us/of...ess.line.width

The setting you are changing has nothing to do with the line width

[Micron]

I might be wrong but to me, those links refer to line controls and control border thickness.
@deepaksharma; Maybe it's just me, but I'm growing weary of feeding you links and reading your follow up posts that indicate you do not carefully read what you're given, be that in a reply in your thread or a link you are given. From the link given about a report border:

The width of the line drawn depends on the DrawWidth property setting.

I have never done this so I can't help implement it.

[deepaksharma]

I might be wrong but to me, those links refer to line controls and control border thickness.

thank you micron this code work

Private Sub Report_Page()

Me.Report.DrawWidth = 5
Me.Line (0, 0)-(Me.ScaleWidth - 40, Me.ScaleHeight), , B

end sub

[Micron]

Glad to see that! Thanks for the rep points. Surely my salary here will be doubled soon.

[Minty]

Surely my salary here will be doubled soon.

There's a queue...

[deepaksharma]

thanks to all..................

[Micron]

There's a queue...

Yes, and it's based on post count! I can almost see you way back there.

[Minty]

Yes, and it's based on post count! I can almost see you way back there.