Convert a Number to a Word

[Colin]

Hi

I would be grateful if someone could tell me if there is
a built in function to convert a number to actual words
ie "62" to "Sixty Two".

I have a finacial database and was thinking of using
something along theses lines to print off Cheques.

Please accept my thanks in anticipation.

Kind regards

Colin

 

[Allen Browne]

See:
How To Convert Currency or Numbers into English Words
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;259663

 

[Douglas J. Steele]

Or, for an Access-specific example, check
http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web".

(The KB article is for FoxPro, so there are syntactical differences)

 

[Adrian Tofan]

check this POST:

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=access_2000&Number=161259

HTH