Format number

[Guest]

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

 

[Rick B]

Do a search on previous posts. This is asked and answered often.

http://groups-beta.google.com/groups?hl=en&q=microsoft.public.access+converting+numbers+to+text

 

[Marshall Barton]

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.

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