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

R

Robert

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.
 
J

John Nurick

Hi Robert,

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