How do I create text for a number like "one thousand (1,000)"?

[bcmarshall]

I'm creating a report which is a legal receipt for shares in a company. In legalese, it's common practice to write the number of shares in words first, and then in numbers, like this:

one thousand three hundred fifty (1,350).

Is it possible to get Access to look at a number field and generate the corresponding text?

All help would be appreciated.

 

[pbaldy]

This should get you started:

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

 

[bcmarshall]

That is ultra cool! Thanks!

 

[pbaldy]

No problemo!