Spelling numbers

[Guest]

Hi there,

Is there a way to make Access return a number in an extensive way, like I
have the field currency with a value of 34,50€ and I want Access to return me
this number like "Thirty four euro and fifty cents".

Thank you for your help

Luís

 

[Marshall Barton]

Is there a way to make Access return a number in an extensive way, like I
have the field currency with a value of 34,50€ and I want Access to return me
this number like "Thirty four euro and fifty cents".

One of these should get you started:

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

 

[Guest]

Thank you so much Marshall. I think that this will help me a lot. I just have
a small question. How do I use the modules... (sorry, but I never worked with
these modules, and your help would be very appreciated) How do I apply them?

All the best,

Luís Graça

 

[Marshall Barton]

Thank you so much Marshall. I think that this will help me a lot. I just have
a small question. How do I use the modules... (sorry, but I never worked with
these modules, and your help would be very appreciated) How do I apply them?

Open a new module in your database then Copy the English
function's code and Paste it into your new module. You can
then use the function by calling it the same way you use any
oither function. For example, you could have text box on a
form or report with an expression like this:

=English(yourcurrencyfield)

 

[Guest]

Dear Marsh,

It worked perfectly. Thank you so much!

Luís Graça