Fra tal til tekst format

The PC's regional settings are responsible for how numbers are formatted. So there should be no problem formattingthem correctly in Word. Dont know how you are getting the data from Access to Word, but I think the problem is in Word and not Access.

Thanks for your respons!

Data is transfered via 'Brevfletning' which normally is used when making labels and such. I just use the same facility to an economic report. Could you tell me how I change the format in Word?

You could try changing the data type from number to currency.

Maybe not a good idea, it places a currency symbol in front. In the properties (table design) change the format to Standard and Decimals to 0 then see how it looks in Word. I'm not to good at useing Word so cant help you there

Still no idea Terry?

I have tried to create a long query where I seperate the number into small fragments eg. 100000 into 100 and 000. I use Left$.... for this. After doing so can the fragments be put together into [100] & "." & [000] and saved in a text format for further use in word.

I can get this to work, but the problem with this solution is that it is space consuming and not handy to work with.

Did you try changing the properties for the field?

"In the properties (table design) change the format to Standard and Decimals to 0"

Hvis du ændrer type i Access til Valuta, skulle det være muligt enten at specificere, at det skal være uden valutasymbolet, eller at sortere det fra, f.eks. hvis du ved, at det fylder 4 tegn, "kr. " eller 2, "$ ". Alternativt kan du måske overføre til Word som valuta, og så i Word taget valutasymbolet væk?

Hej igen. Undskyld forsinkelsen men her er dine point. Løsningen lå ganske rigtigt i Word. Alt + F9 åbner er koderne til flettefelterne og ved at indtaste \# #.##0,00 i enden af feltet, så blev et talformat i Access til et anvendeligt format i Word.

thanks bmhaj, glad to hear you got it working.

og godt nytår