Horizontal Gridlines per column onlvertical gridlines)

[Simplesimon]

I am replicating a report that has gridlines almost as if they were underlines in each column. How can I do this in access.


I have tried to change the colour of the vertical line to 'cut through' the horizontal but cant manage it....any help PLEASE

[June7]

This requires VBA that manipulates a line object to set the x and y values of start and end of line. Here is example from my db.

I created 6 line controls on report and use their Left property as the x value for each of the programmed lines. Could substitute numbers as I did for the y's. The values are in TWIPS (1440 TWIPS per inch). The code is in the report OnPage event.

Private Sub Report_Page()
'1440 twips per inch
Me.Line (Me.lin1.Left, 720)-(Me.lin1.Left, 15120)
Me.Line (Me.lin2.Left, 720)-(Me.lin2.Left, 15120)
Me.Line (Me.lin3.Left, 720)-(Me.lin3.Left, 15120)
Me.Line (Me.lin4.Left, 720)-(Me.lin4.Left, 15120)
Me.Line (Me.lin5.Left, 720)-(Me.lin5.Left, 15120)
Me.Line (Me.lin6.Left, 720)-(Me.lin6.Left, 15120)
End Sub