Hi Guys; hope you're all well!!
I have a 'snaked' column report with headings and subheadings related to groups.
What I'd like to do, which sounds simple enough, is to draw vertical lines from the header to the footer section of the
report, to divide the page up into something that resembles an invoice... (with vertical columns for timesing)
I have cribbed the following code from a Microsoft example, which is meant to do the trick when printing (i.e. the lines are
visible in print preview)..
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Dim lngColor As Long
Me.ScaleMode = 3 'Pixels
Me.DrawWidth = 5 'in Pixels
lngColor = RGB(204, 204, 204)
Me.Line (0, 0)-(0, Me.ScaleHeight), lngColor
Me.Line (162, 0)-(162, Me.ScaleHeight), lngColor
Me.Line (2070, 0)-(2070, Me.ScaleHeight), lngColor
Me.Line (2775, 0)-(2775, Me.ScaleHeight), lngColor
Me.Line (3072, 0)-(3072, Me.ScaleHeight), lngColor
Me.Line (3696, 0)-(3696, Me.ScaleHeight), lngColor
Me.Line (4640, 0)-(4640, Me.ScaleHeight), lngColor
But this only seems to include the lines in whatever section I paste it in?
So, i pasted in every section, but where the detail section doesn't reach the bottom of the page, a gap is left to the
Any help would be much appreciated. Im using Access 2010.