Convert No to Letters

[Haytham]

Hi All, I have a module which converts No into figures.
If the field containing the No is not a true field but containing a function to get any value like e.g. Sum([Amount]), it did not give the proper result.
But the value I want to convert is a result of calculation of subform Sum([Amount])-[Discount] which is another field in my form...
I tried to put my code to read from subform sum but gave an error.. Hope to get any clue please with many thanks

 

[Rich]

Have you tried in the subform footer
=YourFunction([Textbox])
or =YourFunction(Sum([Amount]))

 

[Haytham]

Hi Rich, it gives me error and cursor come to the word sum
Actually, I have a new field which picks a right figure, but it's not read.
I'm trying to write a code to get the sum of field Amount, but I don't know why I'm getting the error msg