Exporting data to external text file

  • Thread starter Thread starter Pat Miller
  • Start date Start date
P

Pat Miller

When I export a numeric field for example 8.275 to a
external txt file the resulting field in the txt file
shows only 8.27 . The field is defined as having 3
decimal positions. Why does it drop or truncate the third
decimal position.
 
Hi Pat,

That's the way Access does it; the reason is buried in the mists of
time. You can get round it by using a calculated field in a query, e.g.
fMyField: Format([MyField], "0.000")
and then exporting the query.
 
Back
Top