Currency to Text formatting

J

Jack

I am designing a gift certificate using MS Access 2002
and when printed in addition to showing the numeric value
of the certificate ($25.00), I want to also print the
text version (Twenty-five dollars). How can I accomplish
this?
Thank you in advance for your assistance
 
G

Guest

Cheryl, Thank you very much. This is exactly what I
need. Only one more questions--how is this function
called?
regards,
Jack
 
C

Cheryl Fischer

Let's say that your Gift Cert is created as an Access report and your field
name for the Dollar Amount of the Gift Cert is named, MyCurrencyAmt ...

Create a text box control on your report and do not bind it to a field in
the underlying table or query. In the Control Source property of the text
box, insert:

English([MyCurrencyAmt]) & " Dollars"
 
G

Guest

Thanks Cheryl. Your help is GREATLY appreciated.
Have a great holiday season.
regards,
Jack
-----Original Message-----
Let's say that your Gift Cert is created as an Access report and your field
name for the Dollar Amount of the Gift Cert is named, MyCurrencyAmt ...

Create a text box control on your report and do not bind it to a field in
the underlying table or query. In the Control Source property of the text
box, insert:

English([MyCurrencyAmt]) & " Dollars"

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Cheryl, Thank you very much. This is exactly what I
need. Only one more questions--how is this function
called?
regards,
Jack
Click to expand...


.
Click to expand...
 
C

Cheryl Fischer

You're most welcome and best wishes to you as well.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Thanks Cheryl. Your help is GREATLY appreciated.
Have a great holiday season.
regards,
Jack
-----Original Message-----
Let's say that your Gift Cert is created as an Access report and your field
name for the Dollar Amount of the Gift Cert is named, MyCurrencyAmt ...

Create a text box control on your report and do not bind it to a field in
the underlying table or query. In the Control Source property of the text
box, insert:

English([MyCurrencyAmt]) & " Dollars"

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Cheryl, Thank you very much. This is exactly what I
need. Only one more questions--how is this function
called?
regards,
Jack
-----Original Message-----
There is code at the following link that will do that
for you:

http://www.mvps.org/access/modules/mdl0001.htm

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I am designing a gift certificate using MS Access 2002
and when printed in addition to showing the numeric
value
of the certificate ($25.00), I want to also print the
text version (Twenty-five dollars). How can I
accomplish
this?
Thank you in advance for your assistance


.
Click to expand...


.
Click to expand...
Click to expand...
 
Top