Exporting adds a space!

[mrfritz44]

I have a batch file that runs an Access macro that exports a query to a .txt file as its final step. This query (and the table the data comes from) has a field in it that is, and needs to be, 125 characters in length. I've checked the entire Access process and this field is always 125 characters long. The problem is, once this record (and field) is exported, the field always has an extra space at the end to give a length of 126 characters. This bombs out the next process in the batch file that expects to see 125 character lines of data.

Any ideas what could be causing this?

Thanks,

Fred

 

[mrfritz44]

Nevermind, problem solved. The field length was buried in the export definition and was set to 126 characters.