Access export to csv

Question

When exporing  x-point and y-point data fields to csv format, the exported data has only 2 decimal places.  IE -119.12345678, when opened in text field is -119.12, using UTF-8, Where might this be controlled.  Might I have to change the field to a text type?

Export wizard 'sees' info correctly, but the text file contains only 2 dec places

Answer 1

Should have mentioned that images were demonstrational, as I was using macro to run/export query on table with the 2 fields setup as number-double type

Answer 2

I may have found a work around. The export is somehow exporting 2 decimal places, by adding a calculation to an additional field (&' ') it is recognized as text and is not cut, and I don't have to reformat the original data as text just for this one external use.

Answer 3

Another technique is to explicitly cast the value as text using the Format() function:

ShowY = Format([Point_Y], "#.0000000")

will show the value with seven decimals.

Answer 4

Thanks John, will try that, but is there a setting somewhere that tells the export to limit to 2 dec places? I was surprised/dismayed that it would do that on it's own accord, without my permission!!  haha