Currency field

[CanWest]

I have a problem

I need to know where to find the currency format that would show the words of the whole dollar amount

For example if the field containe $4,125.50 I would like it to print Four Thousand One Hundred Twenty Five

This is for a tax receipt and it MUST be in that format. Gotta love revenue Canada

Many thanks in advance .....

 

[pbaldy]

This get you started?

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

 

[CanWest]

Thank you for this. Unfortunately I know very little about modules and how to use them. If you could give me a little guidance or point me in the right direction I would greatly appreciate it

Thanks

 

[plog]

You create a new module, copy in the code from that page, save the module, create a query and make one field in that query say something like:

CurrencyText: English([YourCurrencyFieldNameHere])

Then when you run your query the text you want will appear in that spot.

 

[CanWest]

You create a new module, copy in the code from that page, save the module, create a query and make one field in that query say something like:

CurrencyText: English([YourCurrencyFieldNameHere])

Then when you run your query the text you want will appear in that spot.

That worked awesome. Thanks

I don't suppose that you know a way to display only the cents (2 decimal places) in a currency feild

 

[plog]

A currency field acts like a double, so to get just the cents you have to multiply it out so that it becomes a whole number, then use the modulus operation to retrieve the data you want. In a query you would use this:

CurrencyCents: ([YourCurrencyFieldNameHere]*100) Mod 100

 

[CanWest]

Thank you everyone for your help. With your assistance I now have this report looking just the way i want it.

Thanks again