Text box with trailing spaces 1

[annsolomon]

I've posted this in other threads 'cause I'm desperate to get this project finished. Please ignore and accept my apologies if you've already seen this.

I've almost got the 401(k) export finished. Thanks to all who have helped me this past week. One last plea for help (keyword search is still down).

I don't know how to put trailing spaces after data in a text field. For example, a text field must be exported with a length of 30 but the address data in that field is frequently less than 30 characters. I need to add spaces to the end of the address to fill up the field. Ann

 

[cuok]

Hi!

YourText=YourText & space(30-len(YourText))

pls. let me know if its correct!
CUOK

 

[annsolomon]

cuok, thanks a million! I was trying to figure out how to get chr(32) to repeat until the end of the line. duh!
Have a star and my gratitude. Ann