Format number

L

Lamar

On a form I want if someone enters the number "1,234.00" then in another
text box I want the number to display or written as "one thousand two hundred
thirty-four and zero dollars". Is there a way to format this? Thanks for
any help.

Lamar
 
M

Marshall Barton

Lamar said:
On a form I want if someone enters the number "1,234.00" then in another
text box I want the number to display or written as "one thousand two hundred
thirty-four and zero dollars". Is there a way to format this? Thanks for
any help.
Click to expand...


It often a great time saver to check The Access Web for
prebuilt procedures before posting that kind of question.
If you are unfamiliar with that site, add it to your Access
Stuff favorites list.

In this case check this page
http://www.mvps.org/access/modules/mdl0001.htm
 
Top