Option Group

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

I created a form containing a "option group" where 1 =
Active and 2=Obsolete. Now I want to create a report that
will tell if the equipment is active or obsolete. I do
not want the numbers 1 or 2 to appear, I want the words.
How can I do this?

Aurora
 
I am using Access 2000

I created a form containing a "option group" where 1 =
Active and 2=Obsolete. Now I want to create a report that
will tell if the equipment is active or obsolete. I do
not want the numbers 1 or 2 to appear, I want the words.
How can I do this?

Aurora
Click to expand...
Aurora,
In the report, add an unbound control.
Set it's control source to:
=IIf(OptionGroupName]= 1,"Active","Obsolete")
 
Or
=Choose([fieldname], "Active","Obsolete")

--
Duane Hookom
Microsoft Access MVP


I am using Access 2000

I created a form containing a "option group" where 1 =
Active and 2=Obsolete. Now I want to create a report that
will tell if the equipment is active or obsolete. I do
not want the numbers 1 or 2 to appear, I want the words.
How can I do this?

Aurora
Click to expand...
Aurora,
In the report, add an unbound control.
Set it's control source to:
=IIf(OptionGroupName]= 1,"Active","Obsolete")

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
Click to expand...
 
Fred.

Thank you for your answer. Don't ask me why, but I was
trying to do this in the query. Must of been having
another "senior" moment. Again Thank you for your help.

Aurora


-----Original Message-----
I am using Access 2000

I created a form containing a "option group" where 1 =
Active and 2=Obsolete. Now I want to create a report that
will tell if the equipment is active or obsolete. I do
not want the numbers 1 or 2 to appear, I want the words.
How can I do this?

Aurora
Click to expand...
Aurora,
In the report, add an unbound control.
Set it's control source to:
=IIf(OptionGroupName]= 1,"Active","Obsolete")

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
.
Click to expand...
 
Back
Top