Numbers As Text in CSV

[HeyMoe]

This seems it should be easy, but nothing I try is working.

I have a table that gets updated via a form.
The table has a few ShortText fields that contain a default value. One of then is a six digit number.


When I then create a CSV file from this table, the field with this 'number' in it, always shows up with two decimal points!!
I can't seem to make it a text field!
(I need it to be a text field when I use this CSV file later on.)

In the table design, the field is set as ShortText.
I've tried putting the value within quotes, I've tried putting @ in the Format field.
I've tried to set the value via the form....
But every freakin' time, the CSV file shows is as an integer.

Is there something else I'm forgetting.

Thanks very much.

[Welshgasman]

Use Format() function?
Alternatively try surrounding with single or double quote.
Also try the CStr() function.

[HeyMoe]

Use Format() function?
Alternatively try surrounding with single or double quote.
Also try the CStr() function.

Hi Welshgasman. Thanks for the response.
Done all those.
Used Format() and CStr(), enclosed the vale in " " and ' '. No change.
The one thing that's odd, is that the value in the CSV file has '.00' at the end of it.

[Welshgasman]

How are you creating the csv?
Can you upload a sample db?

I have an old DB with sort code and account number as short text and it comes out as

2,"Royal Air Force Benevolent Fund","R.A.F.B.F","RAF","SF","401175","00811689"

[NoellaG]

Check the export settings, I tried an example with Startingstock = short text. The following settings for a text export without formatting gave the correct csv result:

[HeyMoe]

How are you creating the csv?
Can you upload a sample db?

Just with a simple DoCmd.TransferText acExportDelim.

While typing this I double checked exactly what I had. For some reason I included a non-existent 'SpecificationName'.

Jeezus!!!

Thanks for you help.