Results 1 to 2 of 2
  1. #1
    Alex Motilal is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2008
    Location
    Coimbatore, India
    Posts
    192

    Question Column Lines

    Hello Experts,
    I am using the following code to draw perpendicular column lines in Reports:
    Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As Integer)


    Me.ScaleMode = 1
    Me.ForeColor = 0

    Me.Line (0 * 1440, 0)-(0 * 1440, 14400)
    Me.Line (0.791666 * 1440, 0)-(0.791666 * 1440, 14400)
    Me.Line (4.958333 * 1440, 0)-(4.958333 * 1440, 14400)
    Me.Line (7.08333 * 1440, 0)-(7.08333 * 1440, 14400)
    Me.Line (11 * 1440, 0)-(11 * 1440, 14400)
    End Sub
    Suppose I want the 2nd line to be dotted one and the 3rd to be darker, what code I should use?
    Thanks.

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Me.DrawStyle = 2
    Me.DrawWidth = 1

    Me.Line(etc...)



    Sent from my iPhone using Tapatalk

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

Similar Threads

  1. Replies: 14
    Last Post: 07-13-2015, 12:47 PM
  2. error lines
    By lou788 in forum Access
    Replies: 4
    Last Post: 03-08-2015, 09:32 AM
  3. lines on forms
    By Don Webb in forum Forms
    Replies: 2
    Last Post: 11-07-2011, 08:45 PM
  4. Column Lines
    By Alex Motilal in forum Programming
    Replies: 2
    Last Post: 10-26-2011, 06:04 AM
  5. Curved Lines
    By Rawb in forum Reports
    Replies: 3
    Last Post: 10-24-2011, 07:20 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