Convert numbers to text

[MaryLou Eveland]

I need to know if there is a way to convert Numbers to Text ( ie. 12,345.00
to Twelve Thousand Three Hundred Forty Five Dollars and No Cents) .

Thanks,

MaryLou

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0001.htm at "The Access
Web"

 

[MaryLou Eveland]

Thank you. I'm not very familiar with VB yet. I have the
ContractAmount(Numbers field) in my table and want to be able to convert
that amount to Text into another field in the same table. Will what you
gave me allow me to do that?

ML

: Take a look at http://www.mvps.org/access/modules/mdl0001.htm at "The
Access
: Web"
:
: --
: Doug Steele, Microsoft Access MVP
:
: (no e-mails, please!)
:
:
:
: : >I need to know if there is a way to convert Numbers to Text ( ie.
12,345.00
: >to Twelve Thousand Three Hundred Forty Five Dollars and No Cents) .
: >
: > Thanks,
: >
: > MaryLou
: >
:
:

 

[Rick B]

You don't.

You don't store the same data in more than one field in a table.

You can display it that way in your forms, reports, or queries, but you
would not save it. what happens if someone changes an amount? Then the
'words' are wrong if it is saved.

Both of your questions have been answered many times over in these
newsgroups. Please take a moment to go search previous posts on these
topics instead of posting a new thread.

Google.com can be used to read any previous post by clicking the "groups"
link and starting your search string with...

microsoft.public.access

followed by yout serach string such as "storing calculated values" or
"converting numbers to text".

 

[MaryLou]

Thank you for your help, however I only posted the question one other time
and that was in forms.