Converting Number to text

How can I convert a number to text under Access?

Lily wrote:
How can I convert a number to text under Access?

Do you mean you want to convert "123" which is now one of the number
formats into "123" text, possibly so you can change it to "0123" and or sort
it differently. or do you want to change "123" to "one two three"? What
format is it in now, single, double, long etc.?

Generally if it is really a number, it should stay a number in the
database, but you may want to display it as words in reports or forms. If
it is really text, as a part number, or zip code might be, then you should
change the table properties so it is text.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

See:
How to Convert Currency or Numbers into English Words
at:
http://support.microsoft.com/?id=210586

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lily" wrote in message
...
How can I convert a number to text under Access?

Lily wrote:
How can I convert a number to text under Access?

If you mean change 5 to 'five' then have a look at
www.mvps.org/access/modules/mdl0001.htm


--
Joan Wild
Microsoft Access MVP