G
Guest
how can i change a roman number to a text character? example is changing 100
to one hundred
to one hundred
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dirk Goldgar
benj said:how can i change a roman number to a text character? example is
changing 100 to one hundred
See this link:
http://www.mvps.org/access/modules/mdl0001.htm
Modules: Convert Currency ($500) into
words (Five Hundred Dollars)
G
Guest
Thanks! thats what i was looking for
Dirk Goldgar said:See this link:
http://www.mvps.org/access/modules/mdl0001.htm
Modules: Convert Currency ($500) into
words (Five Hundred Dollars)
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
Ù
ياسر
where to put this code?
and what shall i do
and what shall i do
Dirk Goldgar said:See this link:
http://www.mvps.org/access/modules/mdl0001.htm
Modules: Convert Currency ($500) into
words (Five Hundred Dollars)
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
A
Arvin Meyer MVP
Put it in a standard module and call it from a query column like:
Expr1: English([CurrencyFieldName])
Use the query as a form or report recordsource. Make sure that you don't
name the module the same as the function name.
Expr1: English([CurrencyFieldName])
Use the query as a form or report recordsource. Make sure that you don't
name the module the same as the function name.
I
Irivng Shao
hello, what can i do now?
ياسر said:where to put this code?
and what shall i do
J
John Spencer
Copy the VBA into a module and save the module with a name like
modCurrencyToWords.
Then call the function where you need it.
In a query
English([MyNumberField])
As a control source
=English(someValue)
etc.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
modCurrencyToWords.
Then call the function where you need it.
In a query
English([MyNumberField])
As a control source
=English(someValue)
etc.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
J
John Spencer
Actually the routine converts arabic numbers (0-9) to words.
If you want to convert roman numbers (I, V, X, L, M, C) to words or
arabic numbers then you will need another routine to do so. I am not
aware of a routine, but I'm sure one exists and can be located by
searching the web.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
If you want to convert roman numbers (I, V, X, L, M, C) to words or
arabic numbers then you will need another routine to do so. I am not
aware of a routine, but I'm sure one exists and can be located by
searching the web.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================