Access 2000 - Convert Number to Text (check printing)

[yezleb]

I am looking for some quick help. I have a project with a one time printing of a couple thousand checks. I brought all of the data into my db, created my check form, and was able to format all the fields required except for the text version of the dollar amount (i.e. 25.45 to be printed as Twenty-Five and 45/100 dollars). Is there an easy way of creating this text field from a numeric value.

Any help would be greatly appreciated.

Thanks
Rich

 

[THWatson]

Rich
On the Microsoft Knowledge Base, there's an article, #210586, that covers this process.

Tom

 

[RickSpr]

There is also at least one FAQ in the various Access forums for this specific requirement.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[MichaelRed]

faq181-1740



MichaelRed
m.red@att.net

Searching for employment in all the wrong places