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

Jumat, 13 September 2013

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

Lani

In addition to using the Choose function, I caught a glimpse of what might be wrong here. You said something

about putting our suggestions in the criteria. That's not where you should put them. It belongs on the Field Name line.

Field Name ShiftDescription: Choose([Shift], "Day", "Night")

Switching to SQL view it would look like this:

SELECT Choose([Shift], "Day", "Night") as ShiftDescription

FROM MyTable

Bill

--- In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Hi Lani

I think Duane said this already, but you can use the Choose() function.

Let's say the field in your table is called "DayNight" and it has a value of 1 for "Day" and 2 for "Night". Set the ControlSource of your textbox to:

=Choose([DayNight], "Day", "Night")

The Choose() function works by examining the value of the first argument ([DayNight]) and if it is 1 it returns the second argument ("Day"); if it is 2 it returns the third argument ("Night"), etc

Best wishes,
Graham

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mahinalanibaker@yahoo.com
Sent: Friday, 13 September 2013 03:39
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Can you change the value of an option group?

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.

Access Dummy