Dot Leader 1

[tomco22]

Is it possible to have a dot leader on a report such as is available in Microsoft Word. I want each line to format like this:

John Jones......................770.123.4567
Fred Fredricks..................404.321.7654
Sam Smith.......................678.765.4321

For reasons I won't go into it would be cumbersome to use Word Mail Merge.

tomco22
I Nab Terrorists

 

[dhookom]

Sure, check Stephen Lebans site

http://www.lebans.com/leaderdots.htm

Duane
MS Access MVP

 

[SgtJarrow]

there are several ways to accomplish this, but whatever way you chose be sure to remember that for things to line up properly, you will have to use a typewriter type font...something where all the characters are all the same size.

****************************
Computers are possibly the most un-intelligent things ever invented, yet we let them control the world. Possibly a reflection of our own stupidity.

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[dhookom]

I don't think Mr. Lebans would limit your use to a fixed space font. His solutions are generally much more elegant.

Duane
MS Access MVP

 

[tomco22]

dhookom,

The Stephen Lebans site answered my question. Thanks.

Tom
MCSD
I Nab Terrorists