How do I Export Text field right justified and zero filed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am generating a 1098-T text file for IRS. The file is a TEXT format but
some of the fields contain numeric data one is 12 digits right justified and
zero filled. The Export function in Access wants to left justify and blank
fill.
 
Hi Robert,

Use a calculated field like this:
fField: Format([Field],"000000000000")
 
Back
Top