G Guest Mar 1, 2007 #1 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
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 Mar 1, 2007 #2 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.
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.