MSAccess report

  • Thread starter Thread starter Winefride
  • Start date Start date
W

Winefride

I am currently formatting receipts. I want to be able to put the dollar
amount in both as numeral and words. Is there anyway to automate this so that
$100 will generate One Hundred in a query or in the report itself? I do not
know how to code but have some experience using Access for a fairly complex
data base.
 
I am currently formatting receipts. I want to be able to put the dollar
amount in both as numeral and words. Is there anyway to automate this so that
$100 will generate One Hundred in a query or in the report itself? I do not
know how to code but have some experience using Access for a fairly complex
data base.
Click to expand...

See:

Modules: Convert Currency ($500) into words (Five Hundred Dollars)
http://www.mvps.org/access/modules/mdl0001.htm
 
Thank you for the code - but I have to admit I don't know how to apply it in
a query - how do I attach it to a query?
 
Thank you for the code - but I have to admit I don't know how to apply it in
a query - how do I attach it to a query?
Click to expand...

You don't attach it to a query.
Here's what you do.

Copy and paste the code ... everything between

************ Code Start **********
and

************ Code End **********

into a new module. Exit and save the module .
Name it "mdlDollarsToText".

Then, in your query, to convert the currency value into text, add a
new column to the uery grid.

TextDollars:English([CurrencyFieldName])

You can then use the [TextDollars] field in a report or wherever.

If you are wishing to do this directly in a report (i.e. to actually
print out a check), you would use, in an unbound text control:

=English([CurrencyFieldName])
 
Back
Top