+ Reply to Thread
Results 1 to 4 of 4

Underline a row

  1. #1
    Registered User
    Join Date
    03-31-2006
    MS-Off Ver
    Excel 2003
    Posts
    76

    Underline a row

    I create a Word document from Access and need some rows to be underlined.
    But the width of rows is always different. If a row isn't filled with characters fully it's underlined only where characters are typed. Spaces are not underlined.

    So the width of an underlined row is always different.
    How can I solve this problem?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Underline a row

    Hi,

    there's a difference between the underline of text that you can achieve with text formatting and the underline of paragraphs, which will always go to the right hand border of the page.

    Text formatting (Format - Font) will only underline the text.

    Use Format - Borders and Shading to apply an underline to a paragraph.

  3. #3
    Registered User
    Join Date
    03-31-2006
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: Underline a row

    Thank you!

    That's what I actually do. But the point is borders can be drawn only above or below a paragraph. I need it after definite rows.
    That's why I have to split strings and build single paragraphs.
    The other problem is that the up border of the following paragraph erases the bottom border of the current paragraph.

    I do this all in VBA-code from Access and don't know the number of rows in advance.
    It's very inconvenient.

  4. #4
    Registered User
    Join Date
    03-31-2006
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: Underline a row

    Here is the solution:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1