I currently have a number field in a form that is called amount due. I would like to link a field to this amount that will spell out the number. For example the amount field has a value of 35 in it. I would like the linked field to say "thirty five". I can't seem to get anything to work. I can either do this in a query or I can do it in the form. Thanks in advance for all the help.

Thanks,

Mike

Hi,
check: MSKB - how to convert currency/numbs into english words!
HTH
Good luck

Thanks, this works perfectly. Secondly, is there a way in a query to return the value of a number after the decimal places. For example 35.23 and return just 23 or 1281.96 and return 96.

Thanks again,

Mike

Hi,
try a combination of the mid and instr function or the right function since the dot would always be on the third position from the right:

=Mid([YourField],1,InStr([YourField],".")+1)

=Right([YourField],2)

HTH
Good luck

Thanks again,

You're welcome!
Glad I could assist.
Good luck on future projects!

or

([YourField]-Int([YourField]))*100

would work too providing the intial number always has 2 digits after the dp.