String Function

[Guest]

I have a concatenated text box, using String(?,"*") how do I set a lenth that
would fill up the empty space in the text box where the lenth of each record
would vary.
TIA.

 

[Douglas J. Steele]

If you want, say, ten characters, regardless of how long your text input is,
and you want stars to fill up the characters at the end, use something like
Left$(YourString & String(10, "*"), 10)

 

[Guest]

Still can't get the effect I'm looking for.
Perhaps this will illistrate the effect I'm after.

Mr.Smith...................................706-6583
Mr.Wellington............................706-4321
etc.

TIA

 

[Douglas J. Steele]

Sorry, that doesn't really explain the problem. If you're using a
non-proportional font, it's not as simple as padding with a specific number
of characters.

 

[John Spencer (MVP)]

Check out LeaderDots at Lebans' site. He has an example database for doing this.

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