Currency to text

[tmcq87]

I am trying to find how to get a macro that will convert currency to text.
Exmple: in one field I want to $564.14
and have it come up in another field as
Five Hundred sixty four dollars and fourteen cents, or any thing similar. and ideas or maybe a copy of that macro?

 

[R. Hicks]

This would take a brain surgeon to do with a macro. Jump into VBA code and get your feet wet. Check out The Access Web, you will find code that will do exactly what you want.
http://www.mvps.org/access/modules/mdl0001.htm

HTH
RDH

[This message has been edited by R. Hicks (edited 12-30-1999).]

[This message has been edited by R. Hicks (edited 12-30-1999).]

[This message has been edited by R. Hicks (edited 12-30-1999).]

 

[sentry1]

Usage of said code?

Ok, so I'm a total newbie to VBA in Access. Once I paste that code into a module in Access, how do I then call it to convert a dollar amount to words?

 

[boblarson]

Let's say you have a text box that you want the data converted:

In the text box's AfterUpdate event put:

English (Me.YourTextBoxNameHere)

 

[GaryPanic]

don't bust a gut on this one-- check the samples- some clever bunny has already done this --something i will use as some point - i think you need to look at cheque writer or Check writer if your US all the code has been done

its all to do with the number

if x = 1,000 then thousands
if x = 100 then hundred
if x = blur you get the idea

the code once you find it is very easy

g

 

[boblarson]

check the samples- some clever bunny has already done this

The link that was posted in this thread was to the code on Dev Ashish's website. I think he wasn't sure how to call the function, which was English(PutNumberHere)

 

[GaryPanic]

you know me bob - only see half the question (half the time)

memory's good though as i haven't seen this for some time (wish my spelling was as good as my memory)
:-}
g: