Padding string

[John]

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

 

[Guest]

How about using string concatenation, like...

Dim M As String (or M$)
M = Right(" " & "ABC",5)

"ABC" could also be a textbox...

In this case, M would result in " ABC"...

HTH - Bob

 

[RoyVidar]

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