I want to use the Format function to do the following:

VB Code:
  1. sString = "Fred"

  2.  
  3. msgbox format(sString, "??????")

...in order that the output is a 6 character string with leading blanks. i.e. " Fred"

and:

VB Code:
  1. sString = "Fred Bloggs"

  2.  
  3. msgbox format(sString, "??????")

...in order the the string is truncated. i.e. "Fred B"

is this possible using the Format function (I already know how to do this in other ways)?

Thanks in advance

Flustor