RE: [MS_AccessPros] Can you change the value of an option group?

Lani,

If there is no small lookup table, you can use a control source like:

=Choose([YourFieldNameHere],"Option 1 title","Option 2 title")

Duane Hookom MVP
MS Access

________________________________
> From: chas@cartmel.me.uk
> To: MS_Access_Professionals@yahoogroups.com
> Date: Thu, 12 Sep 2013 16:48:12 +0100
> Subject: RE: [MS_AccessPros] Can you change the value of an option group?
>
> Lani
>
> Can you link the field to a lookup table and display the 'description'
> in the report rather than the 'key value'?
>
> Charlie
>
> www.G4EST.me.uk
>
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of 
> mahinalanibaker@yahoo.com
>
> Is it possible to change the value so on a report it doesn't read 1 or
> 2, instead it reads day or night for example? I tried going into the
> wizard and changing it when it gives you the numeric value but it won't
> let me. Has anyone done this before? Or is this just not possible?
>
> Thanks,
> Lani B.

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/