When using the docmd.transfertext delimited, how do you make it delimited with a space? Also, is there a way to format the number fields to a #.00 format before doing this?
Create an Export Specification & set the "Field Delimiter" to {space}. To format numbers, the best thing to do is format them in the table or query you want to export.