I'm having a problem exporting a table that has a field formatted as Field size (Double), Format (standard) and Decimal Places 3. looking at the table everything is fine fields shows 0.624 but when I try to export it to a .txt file if field shows up as 0.62 I've used the External Data and export to Txt file. I've set up a specification with the field type as double but when I export it I don't get the 3 positions. My export code is as follows
Any help is greatly appreciated.
Code:
Vtable = "scores"
apppathx = (StrFolderName + "\" + "scores.txt")
DoCmd.TransferText acExportMerge, "Scores Export Specification", Vtable, apppathx, True