Padding string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 29 Jan 2006 06:08 GMT

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

Reply to this Message

RoyVidar - 29 Jan 2006 10:39 GMT

John wrote in message <#Gy9zpJJGHA.1832@TK2MSFTNGP11.phx.gbl> :

> Hi
>
[quoted text clipped - 4 lines]
>
> 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

Signature

Roy-Vidar

Reply to this Message

steve.minnaar - 29 Jan 2006 10:50 GMT

strOut = Left$(strIn & Space$(x), x)

MS Access - A legend in it's own time.

Reply to this Message