Convert a number to text - where is the text function

[Dave]

I want to convert a number to text. I searched the help files and found a
text function. However I am not able to find the function.

How do I install missing functions?

Thanks

Dave

 

[John Viescas]

Use CStr or concatenate the number with an empty string:

MyNumberToText: CStr(MyNumber)

or

MyNumberToText: MyNumber & ""

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[John Spencer (MVP)]

Do you mean you want to convert 1,254 to "One Thousand Two Hundred Fifty
Four"? IF so, there is no built-in function in Access, but check out the code
at

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

You can add that code to your database in a module and use it.

 

[John Viescas]

Ah! Well, if you're using Access 2000, Help is useless. It lists all the
Excel functions, but few, if any, of them are available in Access. What you
want is the Format function.

Format([MyNumber], "$0.99")

You shouls also be able to look up the Format function in Help. You can do
all sorts of creative things with number formatting, similar to the Text
function in Excel.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)