Formatting numbers as words

[kltino]

I found the link to http://www.mvps.org/access/modules/mdl0001.htm suggested
in an earlier question. How do I attach this to a specific field? I have a
dollar amount that I need to print in words and I don't know how to
accomplish that. Thanks for any help.

 

[fredg]

I found the link to http://www.mvps.org/access/modules/mdl0001.htm suggested
in an earlier question. How do I attach this to a specific field? I have a
dollar amount that I need to print in words and I don't know how to
accomplish that. Thanks for any help.

Use an unbound text control in your report.
Set it's control source to:
=English ([FieldName])

 

[kltino]

Thank you, I tried it and it worked.

I found the link to http://www.mvps.org/access/modules/mdl0001.htm suggested
in an earlier question. How do I attach this to a specific field? I have a
dollar amount that I need to print in words and I don't know how to
accomplish that. Thanks for any help.

Use an unbound text control in your report.
Set it's control source to:
=English ([FieldName])