If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Converting Number to text
How can I convert a number to text under Access?
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
converting text box to combo box and using linked data | Ted | New Users | 2 | August 21st, 2004 12:06 AM |
Refreshing a text box based on other text box values | ExcelMan | Using Forms | 2 | July 29th, 2004 01:48 PM |