Rounding numbers when writing a Check

[Kris Neuman]

I have a database that prints settlements to customers. I am wanting a cover
page to be the page to print directly on the check. The problem I am having
is I don't know how to turn the numbers into written text. For example, if I
have a check to write for $100.00, is there a way to convert that to spell
out "One-hundred dollars"?

Even if that is not possible, I could do a text box that displays the whole
dollar amount "100" and simply have "dollars" coded after it. The problem I
have with this is that if the check amount is for $99.55 the whole dollar
amount wants to round to 100. How do I get the data to simply cut off the
decimals and then in another box I would need it to simply cut off the dollar
amount and use only the decimals?

 

[fredg]

I have a database that prints settlements to customers. I am wanting a cover
page to be the page to print directly on the check. The problem I am having
is I don't know how to turn the numbers into written text. For example, if I
have a check to write for $100.00, is there a way to convert that to spell
out "One-hundred dollars"?

Even if that is not possible, I could do a text box that displays the whole
dollar amount "100" and simply have "dollars" coded after it. The problem I
have with this is that if the check amount is for $99.55 the whole dollar
amount wants to round to 100. How do I get the data to simply cut off the
decimals and then in another box I would need it to simply cut off the dollar
amount and use only the decimals?

See:
Modules: Convert Currency ($500) into words (Five Hundred Dollars)

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