number to word

[Akshaya]

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.

[zynder]

Can you post your function?

[Bruce Fox]

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

(a guess without seeing your Function)

[Merri]

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

Public Function num_to_word( ... ) As String

[Akshaya]

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

[si_the_geek]

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.

[Merri]

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

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.

[sessi4ml]

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

[RhinoBull]

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

So where is it?

[sessi4ml]

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

[RhinoBull]

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