Access Fixed width txt file creation

Question

I am creating a fixed width .txt file. I have a phone number of 1112223333 and when the 13 width file is created it displays the number as 1112223333.0. I also have an age field that has a width of 3 and it shows as 23. Can someone point in the right direction to remove both the .0 and . issues

Answer 1

What is the datatype of the phone number in your Access table? It should be text, not any flavor of Number (you don't do calculations with phone numbers, usually!)

Try exporting Cstr([phonenumber]) or Format([phonenumber], "0000000000") to explicitly cast the field as a String.

Answer 2

I don't get the same results as you do. Perhaps it's the version of MS Access. You could try create a query with the correct formats and then export the query.