Convert Numbers to text

[adam]

Hi Anyone,

I have included a module in my database where I'm trying to convert the numbers into text.

But my formulas aren't working. How could I overcome this?

Any help on this would be kindly appreciated.

Thanks in advance.

[HansV]

The cause of the problem is that you have given the code module the same name (ConvertCurrencyToEnglish) as the function you want to use. This confuses Access. You should give the module another name, for example basConvert (but you're free to choose something else).

Moreover, you should add the following at the beginning of the function ConvertCurrencyToEnglish:

Code: Select all

         If IsNull(MyNumber) Then
           Exit Function
         End If

This avoids an error message when the Total text box hasn't been filled yet.

[adam]

Thanks for the help Hans. If I want the currency to another country should it be changed by changing the text such as dollars and cents for example to rupees and paisa or whatsoever

[HansV]

If it's OK to use the thousand - million - billion way of counting, it is sufficient to change the text for dollar and for cent within the quoted strings.

It becomes more complicated if you want to use the Indian system of counting, with thousand - lakh - crore.

[adam]

Thanks for the help. How could I make the numbers to appear as decimal places.

Suppose if 3 is written it will appear as 3.00

[HansV]

You don't need the convert function for that - simply set the Format property to Fixed.

[adam]

Thanks for the help Hans.