Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Access 2000 Report/Leader Dots (2000 SP2)

    I was wondering if I'm able to fill a field in with leader dots. For instance, name...... (333) 333.3333. Where name and phone number are 2 different fields and I want the name field to justify out with leader dots. Any creative solutions? Thanks much

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Report/Leader Dots (2000 SP2)

    Well, you could use the String() function. That allows you to produce a string of the same character of a given length:

    =[name] & String(60-(Len([name])+Len([phonenumber])),".") & [phonenumber]

    Just play with the number 60 until you get total field the length that you want it.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Report/Leader Dots (2000 SP2)

    On further consideration, this will not work. I failed to consider the varying width of different characters. Just having the same number of characters will not make them line up properly.

    You could make a text box composed entirely of dots then overlay this text box with your name and phone number boxes at each end.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Report/Leader Dots (2000 SP2)

    You can get over the problem of "varying width of different characters" by using a font with fixed spacing.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Report/Leader Dots (2000 SP2)

    When I found this on the vb world site I recalled your post!

    I

Posting Permissions

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