Grid Lines on a Report

G

GLS

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
 
A

Allen Browne

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