number to word

Dear friends,

I have a function for converting number to word for netamt.

function name is num_to_word.

How to call the function in a form(while calculating netamt).Please guide me.

Can you post your function?

vb Code:

num_to_word(this_is_the_number_parameter_I_pass)
 
'Eg.
MsgBox num_to_word(14)

(a guess without seeing your Function)

If the function is in a module, you want to declare it Public:

Code:

---

Public Function num_to_word( ... ) As String

---

Thanks for your mail.

I want to call num_to_word function in select function.
How to call funtion in a select query?

suppose net_amt column.
select num_to_word(val(net_amt)) ........gives error

Assuming that you mean a Select query (SQL), you can't - you can only use functions that the database provides.

You will need to run the function against the recordset fields (as part of your display process) instead.

Or have an index table in the database that can give the wanted results, ie.

Code:

---

SELECT a.id, b.word FROM amounts a, words b WHERE b.word_id = a.net_amt

---

word_id in this sample would link a certain number to certain word. The words table would be very simple, having only word_id and word columns in the table.

A number to word? I have that program below...

Quote:

---

Originally Posted by sessi4ml

A number to word? I have that program below...

---

So where is it? :)

?
My links.... Number to Words/66 digits

Ah, if it's in your signature then I don't see anybody's sigs... Sorry.