John wrote in message <#G**************@TK2MSFTNGP11.phx.gbl> :
Hi
Is there a way in access 97 to pad a string with spaces such that the
resultant string is always x characters long?
Thanks
Regards
I think the String function exists a97. Say you have a variable strTest
containint "hello"
strNewWar = strTest & String(20 - len(strTest), "@")
I think also the LSet statement could be used
strNewWar = "12345678901234567890"
LSet strNewWar = strTest
--
Roy-Vidar