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
|
|||
|
|||
Change numbers to words
I have a table with a number field so that I can use an option group to
select the data. When I print a form I need it to print the word that coresponds to the number. Is that possible? |
#2
|
|||
|
|||
Change numbers to words
On Mon, 21 Nov 2005 11:23:03 -0800, Dennis the Safety Nerd wrote:
I have a table with a number field so that I can use an option group to select the data. When I print a form I need it to print the word that coresponds to the number. Is that possible? Assuming the option values are 1, 2, 3, etc., as control source of an unbound control: =IIf [FieldName] = 1,"This",IIf(FieldName] = 2, "That","Other")) or if you have many choices, you can use Choose(): =Choose([FieldName],"This","That","Other") -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Change numbers to words
look at a thread in
microsoft.public.access titled How can I assign a letter code to a date? on 2 November 2005 14.06 I don't know if you want to do the same thing but Brendan Reynolds sorted it out for me. "Dennis the Safety Nerd" ha scritto nel messaggio ... I have a table with a number field so that I can use an option group to select the data. When I print a form I need it to print the word that coresponds to the number. Is that possible? |
#4
|
|||
|
|||
Change numbers to words
never mind, I miss read your question
"Michael" ha scritto nel messaggio ... look at a thread in microsoft.public.access titled How can I assign a letter code to a date? on 2 November 2005 14.06 I don't know if you want to do the same thing but Brendan Reynolds sorted it out for me. "Dennis the Safety Nerd" ha scritto nel messaggio ... I have a table with a number field so that I can use an option group to select the data. When I print a form I need it to print the word that coresponds to the number. Is that possible? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can you display numbers as words in excel (eg. 10 as ten)? | Stefan White | General Discussion | 2 | October 5th, 2005 04:38 PM |
How can I change positive numbers to negative, i.e. change 50 to - | godwingi | General Discussion | 5 | February 28th, 2005 05:41 PM |
change numbers in a column and continue number's in seq onto each. | nhtpclerk | Tables | 1 | December 10th, 2004 08:47 PM |
moving numbers between columns without moving words | Papadapa | Worksheet Functions | 2 | December 18th, 2003 04:36 PM |
Formula to change numbers into words? | friend | Worksheet Functions | 2 | September 28th, 2003 05:47 PM |