On Wed, 16 Apr 2008 16:06:00 -0700, Winefride wrote:

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?

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])

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail