Grid Lines on a Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GLS - 01 Mar 2007 14:56 GMT

Can anyone advise me as to how to include grid lines on an Access XP report
set out in landscape format.

Thanks in advance.

GLS

Signature

GLS

Reply to this Message

Allen Browne - 01 Mar 2007 15:08 GMT

Use the Line method in the Page event of the report.

This example draws a red line from top to bottom:

Private Sub Report_Page()
Me.Line (Me.ScaleTop, Me.ScaleLeft)-(Me.ScaleTop, Me.ScaleHeight), vbRed
End Sub

To achieve the grid, use 2 loops (one for the vertical lines, another for
the horizontal lines.)

Measurements are in twips, where 1440 twips = 1 inch.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Can anyone advise me as to how to include grid lines on an Access XP
> report
[quoted text clipped - 3 lines]
>
> GLS

Reply to this Message