Convert a number to text - where is the text function

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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)
 
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)
 
Back
Top