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?

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

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?

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?