Spelling numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
lmgraca said:
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?
Click to expand...


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)
 
Back
Top