E
Edd Moser
I am triing to convert a number to text. 45 to forty five.
A
ali kwok
Edd
What is the range of possible values for your numeric variable? In any case a table or array would probably be the simplest way: eg, a 10 by 4 array could store the english words for the 10 numerals in four positions (only the teens would slightly complicate the algorithm - pity we don't just say "nine", "onety", "onety one", "onety two", etc)
If this sounds promising but you need more help, reply here
Cheers, Al
----- Edd Moser wrote: ----
I am triing to convert a number to text. 45 to forty five.
What is the range of possible values for your numeric variable? In any case a table or array would probably be the simplest way: eg, a 10 by 4 array could store the english words for the 10 numerals in four positions (only the teens would slightly complicate the algorithm - pity we don't just say "nine", "onety", "onety one", "onety two", etc)
If this sounds promising but you need more help, reply here
Cheers, Al
----- Edd Moser wrote: ----
I am triing to convert a number to text. 45 to forty five.
G
Grumpy Aero Guy
good luck.... (sorry, couldn't resist) 
I guess you could write a function that parses this number and creates text
out of it.....
I am thinking about using the "left" function with an integer variable as
its argument. First you would need to get the number of digits of the
original number...there are several ways to do this programatically.
You'd have to create several string variables and do a little concactenation
of the string variables in creating the final "pass back" value.
It could be done---painful though.
May I ask why you need this?
I guess you could write a function that parses this number and creates text
out of it.....
I am thinking about using the "left" function with an integer variable as
its argument. First you would need to get the number of digits of the
original number...there are several ways to do this programatically.
You'd have to create several string variables and do a little concactenation
of the string variables in creating the final "pass back" value.
It could be done---painful though.
May I ask why you need this?
C
Cheryl Fischer
The Access Web has code that will do that for you:
http://www.mvps.org/access/modules/mdl0001.htm
The code as written expects a Currency type, but it can easily be modified
to accept a Long or other numeric type.
hth,
http://www.mvps.org/access/modules/mdl0001.htm
The code as written expects a Currency type, but it can easily be modified
to accept a Long or other numeric type.
hth,
V
Van T. Dinh
Se if you can use The Access Web article:
http://www.mvps.org/access/modules/mdl0001.htm
HTH
Van T. Dinh
MVP (Access)
http://www.mvps.org/access/modules/mdl0001.htm
HTH
Van T. Dinh
MVP (Access)