problem 2

[12011977]

I need to write on report number like text for example
10.500,50 USD = thenthousandfivehundred and 50/100 USD

is there some code so no metter wich number is to write it like text

thanks

 

[dhookom]

There is a function for this at

http://www.mvps.org/access/modules/mdl0001.htm.

You may need to modify it a little to meet your needs.

Duane MS Access MVP

 

[12011977]

Dear Duane

thanks for replay. but I am not fmiliar with modulesin access (I am beginer) so please explain me how to do it

On report I have calculated field [Ammount Due] and I want to convert it in other textbox

Goran

 

[12011977]

I have also visit

http://support.microsoft.com/kb/95640

but omething is not working

 

[ck1999]

12011977,

1. Create a module and post the function from your link
2. Create a txtbox on your report lets call it txtcurrency
3. in form properties go to events
4. on the print select even procedure then click the ... button to the right
5. paste ConvertCurrencyToEnglish([amount due])
6. Preview report

see if this works for you.

ck1999

 

[ck1999]

step 5 should be

paste

txtcurrency = ConvertCurrencyToEnglish([amount due])

ck1999

 

[dhookom]

In addition to ck1999 steps, make sure you save the module with a name that is not the name of a function or procedure.

Duane MS Access MVP