Convert numbers to text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MaryLou Eveland - 15 Jul 2005 01:36 GMT

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

Reply to this Message

Douglas J. Steele - 15 Jul 2005 01:44 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(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

Reply to this Message

MaryLou Eveland - 15 Jul 2005 02:43 GMT

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"
[quoted text clipped - 5 lines]
: >
: > MaryLou

Reply to this Message

Rick B - 15 Jul 2005 14:04 GMT

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".

Signature

Rick B

> 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
[quoted text clipped - 14 lines]
> : >
> : > MaryLou

Reply to this Message

MaryLou - 15 Jul 2005 19:58 GMT

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

> You don't.
>
[quoted text clipped - 34 lines]
>> : >
>> : > MaryLou

Reply to this Message