String Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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