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?
Click to expand...

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" <DennistheSafetyNerd@discussions.microsoft.com> ha
scritto nel messaggio
news:2F375911-9AC9-469B-9A5A-C56C43A891EE@microsoft.com...
 
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" <DennistheSafetyNerd@discussions.microsoft.com>
ha scritto nel messaggio
Click to expand...
 
Back
Top