Combo Box

#1 (**permalink**) 28-Jul-2006, 08:23 AM

I have recently taken over a database designed by someone else. I would like
to make a report using a combo box that was set up using a # to identify a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11788-combo-box.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788
field. I would like to show the value instead of the # in my report (eg.
1=Female, 2=Male).When I create the query only the number shows. How do I do
this. I would like to keep the # for inputing as it is easier than typing in
the value.
Any help is greatly appreciated. Thanks. Jamie

*

#2 (**permalink**) 28-Jul-2006, 08:23 AM

Jamie

Add a field into your query. Use the IIF() function to derive "Male" or
"Female", based on the #.

Use that new field instead of the # field.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Jamie" wrote in message
news:6CA6D7CE-BB5B-422B-AAE5-FB9B697557C1@microsoft.com...
>I have recently taken over a database designed by someone else. I would
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788
>like
> to make a report using a combo box that was set up using a # to identify a
> field. I would like to show the value instead of the # in my report (eg.
> 1=Female, 2=Male).When I create the query only the number shows. How do I
> do
> this. I would like to keep the # for inputing as it is easier than typing
> in
> the value.
> Any help is greatly appreciated. Thanks. Jamie

#3 (**permalink**) 28-Jul-2006, 08:23 AM

Jamie,
Formatting Male for a 1 and Female for a 2 on a report will not have any effect on how
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788
you enter the 1 or 2 on your form. So, no worry on that.

Assuming a field called Gender with numeric values of either 1 or 2...
On your report, place an unbound text control with a ControlSource of...

= IIF(Gender = 1, "Male", "Female")

Now instead of displaying the Gender number you'll get "Male or "Female"

And... don't forget options for 3 = "Transgender" or 4 = "Not Sure".... :-D

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788

"Jamie" wrote in message
news:6CA6D7CE-BB5B-422B-AAE5-FB9B697557C1@microsoft.com...
>I have recently taken over a database designed by someone else. I would like
> to make a report using a combo box that was set up using a # to identify a
> field. I would like to show the value instead of the # in my report (eg.
> 1=Female, 2=Male).When I create the query only the number shows. How do I do
> this. I would like to keep the # for inputing as it is easier than typing in
> the value.
> Any help is greatly appreciated. Thanks. Jamie

#4 (**permalink**) 28-Jul-2006, 08:23 AM

Jeff,
I'm not sure what you mean. Still pretty new.

"Jeff Boyce" wrote:

> Jamie
>
> Add a field into your query. Use the IIF() function to derive "Male" or
> "Female", based on the #.
>
> Use that new field instead of the # field.
>
> Regards
>
> Jeff Boyce
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788
> Microsoft Office/Access MVP
>
>
> "Jamie" wrote in message
> news:6CA6D7CE-BB5B-422B-AAE5-FB9B697557C1@microsoft.com...
> >I have recently taken over a database designed by someone else. I would
> >like
> > to make a report using a combo box that was set up using a # to identify a
> > field. I would like to show the value instead of the # in my report (eg.
> > 1=Female, 2=Male).When I create the query only the number shows. How do I
> > do
> > this. I would like to keep the # for inputing as it is easier than typing
> > in
> > the value.
> > Any help is greatly appreciated. Thanks. Jamie
>
>
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788

#5 (**permalink**) 28-Jul-2006, 08:23 AM

On Tue, 20 Jun 2006 12:12:03 -0700, Jamie wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11788

> I have recently taken over a database designed by someone else. I would like
> to make a report using a combo box that was set up using a # to identify a
> field. I would like to show the value instead of the # in my report (eg.
> 1=Female, 2=Male).When I create the query only the number shows. How do I do
> this. I would like to keep the # for inputing as it is easier than typing in
> the value.
> Any help is greatly appreciated. Thanks. Jamie

Use an unbound text control.
=IIf([FieldName] = 1,"Female","Male")

If there is a chance that neither has been selected:
=IIf([FieldName] = 1,"Female",IIf([FieldName] = 2,"Male","Not
Selected"))
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail