dot leaders in an Access report

[Guest]

I have a database in Access for people's names and phone numbers just like a
phone book. I am attempting to create a report to print that includes the
person's last name, trimmed, plus their first name. Then I would like a dot
leader with their phone number right justified.

I have been unable to find the instructions to do this.

 

[Rick B]

I do it by making my name field stretch all the way to my phone field. My
name field contains the following...

=[LastName] & ", " & [FirstName] &
"...........................................................................
............."


Then you get...

Smith, John............................................ (713) 555-1212

 

[Stephen Lebans]

See:
http://www.lebans.com/leaderdots.htm
LeaderDots.zip is a database containing functions to allow a user to
fill in the space between 2 controls with leading dots.

NEW - Feb. 15/2000 Ver 2.0. You can now use the Alignment property for
both the Left and Right Columns. Fix formatting Bug on long lines.

New Jan. 02/2001 A "real" Phone Book Report based on a modified version
of LeaderDots. Created by Chad Edie. Really Sharp!
TelephonePhoneBook.zip

Version 1.0 includes 2 functions. One for Single output lines and one
for Multiple output lines

Produce leading dots between 2 strings.
Like you see on Menu's etc. For example:
Hamburger..........$3.99
HotDog ...............$2.99
The Singleline version supports Left, Right
and Center Alignments for the
Left Column. The MultiLine version only supports Left Alignment.



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.