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
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
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
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.