convert roman numbers to text in MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i change a roman number to a text character? example is changing 100
to one hundred
 
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.
 
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
'====================================================
 
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
'====================================================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003. MultiSelect. FOR DUMMIES 0
Sorting Roman Number 3
Convert numbers to roman numbers 5
When pasting text into text box, it changes to Times New Roman, but why? 4
convert Times New Roman Special G1 into arial 1
Save formula result into a field 0
Access - How to set Author, Title, Subject etc using VBA 0
Calculating average in a large dataset 2

Back
Top