Post reply

Problem adding dots till the end of the cell

  • June 20, 2012 at 3:46 am

    #257831

    Hi all!

    i need to fill the rest of the cell with dots after some value, like:

    "some value ............................................"

    "some other value ...................................."

    i have already tried it with setting into cell:

    =Fields!value.Value & RSet("......................................................",len("......................................................")-len(Fields!value.Value))

    but it didn't work, cause of the difference in character spacing, or format and font.

    Thank you in advance!

    I appreciate your help!

  • June 21, 2012 at 2:08 pm

    #1504222

    Try using the border property of the cell. If you set the Top to None, and the bottom to Dotted you sort of get what you're wanting.

  • June 22, 2012 at 5:30 am

    #1504439

    Thank you for response!

    I needed dots in the line with text, but the border is underneath it.

    I have solved it by simply adding a lot of dots after my text and setting cell on CanGrow -> False :)))

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply