I am using the TransferText Method to export a fixed length file that is used to create checks. How can I format the amount (text field) so there are no leading zeros and the data is aligned to the right in the field?
Use Format(YourField, " ". This will align YourField to the right and fill in with spaces until it is eight characters long. Of course, you can make it a long as you like by adding or taking away spaces between the quotes.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.