Is it possible to add a vertical line between two columns in a report? Thanks.
Is it possible to add a vertical line between two columns in a report? Thanks.
You should be able to just insert a vertical line in 'Design View'
That's just it, I cannot see anything anywhere in the design view? The only thing I can find is adding a line (which you can stretch and angle as much as you like) and then add that in each part of the report which doesn't work at all, I was kind of thinking like something to do with page borders etc somewhere or adding a line in the page setup or something, but I cannot see anything so far? In actual fact I can't see page borders either, is adding one of those possible?
Can you post the db (sans confidential info) or some screen shots for analysis? Having trouble visualizing the report to advise since there are probably a few different things you can do.
EDIT.
Take a look at this thread, it has all you need in terms of pics and a sample of the db etc. https://www.accessforums.net/access/...tml#post183949
Thanks.
If you only want vertical lines, the only thing I can see with that set up is inserting a line that is as tall as the 'Details' section that should carry through the length of the report. Set the width to 0" and the height to whatever the 'Detail' height is.
Otherwise, you could tighten everything up and use the borders of the Text Boxes.
Do you mean a vertical line between textboxes or do you mean between columns of a columnated report?
Here is my code that works for both:
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
I created 6 lines in my report. Their Left property is referenced to provide the positions of the constructed lines. Could put actual numbers instead.
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.