Change numbers to words

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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")
 
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" <[email protected]> ha
scritto nel messaggio
news:[email protected]...
 
never mind, I miss read your question

Michael said:
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" <[email protected]>
ha scritto nel messaggio
 
Back
Top