Full Version: Spell out a number
UtterAccess Forums > Microsoft® Access > Access Forms
barga43
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
freakazeud
Hi,
check: MSKB - how to convert currency/numbs into english words!
HTH
Good luck
barga43
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
freakazeud
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
barga43
Thanks again,
freakazeud
You're welcome!
Glad I could assist.
Good luck on future projects!
iandouglas
or
[YourField]-Int([YourField]))*100
would work too providing the intial number always has 2 digits after the dp.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.