Left align 2

[mcginty]

Hi all,

I have text in a 20char text field which I want to left align and pad out any remaining spaces with spaces in a query

I can left align the data (Format([field1],!)and I can pad out the spaces (Format([field1],"@@@@..&quot, but I can't seem to do both.

Any suggestions would be welcome.
Ted

 

[mpastore]

mystr: Trim([sStr]) & Space(20 - Len(Trim([sStr])))

 

[wemeier]

mcginty,

mpastore is correct in his solution. You can also use:

mystr: Left(Trim([sStr]) & Space(20),20)

This will give the same results but is slightly faster because it reduces the number of computations that are needed. In a long query, it could make a difference.


Cruising the Information Superhighway
[sub] (your mileage may vary)[/sub]

 

[mcginty]

Great, Guys,

Thanks for the help!