Converting Number to text

  • Thread starter Thread starter Guest
  • Start date Start date
Lily said:
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.
 

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

Back
Top