Share via

DoCmd.TransferText truncates decimal representations of double-precision numbers

Anonymous
2016-11-09T21:48:24+00:00

I am using DoCmd.TransferText to output a table to a text file, which can then be zipped and emailed using other software.  DoCmd.TransferText rounds decimal numbers to two digits after the decimal point.  How can I get it not to do this?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2016-11-10T04:15:07+00:00

    I noticed this too. You can solve it by creating a query on this table and adding a column with either Format or CStr to convert your Double to Text.

    Was this answer helpful?

    0 comments