Results 1 to 7 of 7
  1. #1
    jtalbot0001 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    20

    Can you add a vertical line between a two column report?

    Is it possible to add a vertical line between two columns in a report? Thanks.

  2. #2
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    You should be able to just insert a vertical line in 'Design View'

  3. #3
    jtalbot0001 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    20
    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?

  4. #4
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    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.

  5. #5
    jtalbot0001 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    20
    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

  6. #6
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299
    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.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DCount on report - per line
    By justinwright in forum Reports
    Replies: 4
    Last Post: 04-13-2012, 10:38 AM
  2. Select line from a form for a report
    By drf3794 in forum Access
    Replies: 3
    Last Post: 03-17-2011, 11:01 AM
  3. Vertical Fields on Report
    By jocallahan in forum Reports
    Replies: 3
    Last Post: 10-09-2008, 07:22 PM
  4. Replies: 3
    Last Post: 03-24-2006, 08:40 AM
  5. Replies: 2
    Last Post: 12-19-2005, 09:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums