Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Draw a continuous verticle line in a report between two columns.

Discussion in 'Information Technology' started by Glo, Nov 17, 2005.

  1. Glo

    Glo
    Expand Collapse
    Guest

    I want to draw a continuous verticle line in a report between two columns of
    data, but the ling breaks where the cell data wraps. Is there a way to
    control the placement of lines where there is no break?
     
  2. Loading...

    Similar Threads Forum Date
    Harinder Sikka Withdraws Nanak Shah Fakir Movie Hard Talk Apr 22, 2015
    S Asia Naam Ras 2014: Spiritual Sikh Event Draws More Non-Sikhs Breaking News Jan 4, 2015
    Sikh Coalition Sikh Coalition Draws Attention to Recent Crimes Against Sikhs in the USA Sikh Organisations Aug 16, 2014
    Canada First Turban Day observed in Toronto, draws large crowd Breaking News Apr 1, 2014
    USA American rapper makes racist comments about Sikh man, draws flak Breaking News Apr 1, 2014

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 16 Nov 2005 10:38:16 -0800, Glo wrote:

    > I want to draw a continuous verticle line in a report between two columns of
    > data, but the ling breaks where the cell data wraps. Is there a way to
    > control the placement of lines where there is no break?


    Look up the Line method in VBA help.
    Place the code in the report's Page event, not the detail event.

    Adjust the argument values as needed.

    Dim X1, Y1, X2, Y2 As Single
    Me.DrawStyle = 0
    Me.DrawWidth = 1 ' set the thickness of the line
    ' Set the coordinates and draw a line down the middle of the page.
    X1 = Int(Me.ScaleWidth / 2) ' find the middle of the page
    Y1 = Me.Section(acPageHeader).Height ' start just below the page
    header
    X2 = X1
    Y2 = Me.ScaleHeight ' set length of line
    Me.Line (X1, Y1)-(X2, Y2)
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Trina Jackson

    Trina Jackson
    Expand Collapse
    Guest

    Re: Draw a continuous verticle line in a report between twocolumns.

    In article <B5D5C713-7B21-4358-B0E8-6A92F2632A45@microsoft.com>, Glo
    <Glo@discussions.microsoft.com> wrote:

    >
    > I want to draw a continuous verticle line in a report between two columns of
    > data, but the ling breaks where the cell data wraps. Is there a way to
    > control the placement of lines where there is no break?

    this is not your right email adress

    do not send anything to me again
     

Share This Page