Results 1 to 2 of 2
  1. #1
    Simplesimon is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2014
    Posts
    1

    Horizontal Gridlines per column onlvertical gridlines)


    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

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

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

Similar Threads

  1. disappearing gridlines
    By lugnutmonkey in forum Reports
    Replies: 2
    Last Post: 05-06-2013, 01:26 AM
  2. Cannot see gridlines in table Access 2010
    By bikeordie1 in forum Access
    Replies: 1
    Last Post: 04-22-2013, 01:46 PM
  3. Copied report columns, gridlines uneditable
    By hardwood in forum Reports
    Replies: 1
    Last Post: 06-14-2011, 06:22 PM
  4. Replies: 0
    Last Post: 05-07-2011, 04:24 PM
  5. Ruler and Gridlines
    By Alex Motilal in forum Forms
    Replies: 1
    Last Post: 05-11-2010, 01:28 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