Currency to Text formatting

  • Thread starter Thread starter Jack
  • Start date Start date
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
 
Cheryl, Thank you very much. This is exactly what I
need. Only one more questions--how is this function
called?
regards,
Jack
 
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"
 
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...
 
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...
 
Back
Top