trailing dots in fields

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi
I'm trying to put trailing dots in a field on a report as
follows. They need to fill the empty space between the end
of the text and the start of the next field.

NAME PHONE
John ............1234567
Mary Anne........9876543

can anyone suggest a way

Thanks
 
Phil:

To do this, you concatate the dots to the value of the field. You can do
this either in teh underlying query or in the report control itself. If
you have a field called Person, and you want to do this in the query, then
alias the name of the field and add the dots like this:

PersonName: [Person] & String(150,".")

If you want to do it in the report (which is slightly faster, especially
across a network) then alias the control name (i.e. change it from being the
same name as the field) and then set the control source to be:

=[Person] & String(150,".")

HTH
 
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.
 
Back
Top