Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format a Value

Status
Not open for further replies.

nia

Programmer
Apr 23, 2001
4
US
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?
 
Hi!

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.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top