Converting Option Group number values to text values

[Guest]

I have an Option Group in a table called "tbl_Core" with a field called "Recorder Evaluation" consisting of three choices: Unevaluated, Not Eligible, and Eligible. I have a Form created from tbl_Core called "frm_Core", and the Option Group sets ups nicely. These store the values in tbl_Core as 1,2,3. OK, works fine

I have another Table called "tbl_Summary." I created a form, "frm_Summary", from a Query (qry_Summary) built on tbl_Core. The Recorder Evaluation field in frm_Summary shows "1 or 2 or 3". Works OK

Problem: In frm_Summary, I can't use "1,2,3" -- it has to be "U,NE,E". Also, I would like to return those same text values to a (new) text field in tbl_Core...let's call it, "Evaluation Value Conversion". I'll use those values elsewhere too

I can create an Immediate f (unbound) text box in frm_Core, and it works fine
FYI: IIf([Recorder Evaluation]=1,"U",IIf([Recorder Evaluation]=2,"NE",IIf[Recorder Evaluation]=3,"E"))

Does the trick...but only for the unbound text box on frm_Core. The calculated expression above occurs in the ControlSource property of that box. I understand that an unbound box cannot pass its value back to a table

But that's what I need to do! I would want to store "U,NE,NE" in Recorder Evaluation, but since that's a Number control, no dice. So if that doesn't work, then I could store it in Evaluation Value Conversion (text field) in tbl_Core. But how? Nothing I've tried (macros, even expressions, etc.) works

If I can get "U,NE,E" SOMEWHERE in tbl_Core, then I can use that field to pass the U,NE,E values to frm_Summary and everywhere else I may need them (short of resorting to a combo box, which is not what the client wants)

Bottom line: how do I get U,NE,E into a field in tbl_Core from an Option Group in frm_Core??

Grrrrrrrrrr!!

 

[Duane Hookom]

It sounds like you are storing duplicate or summary data which isn't
recommended.
You can always use an expression like:
=Choose([Recorder Evaluation],"U","NE","E")
There should be no reason to store any other value. My clients would never
see the numbers.

--
Duane Hookom
MS Access MVP

I have an Option Group in a table called "tbl_Core" with a field called

"Recorder Evaluation" consisting of three choices: Unevaluated, Not
Eligible, and Eligible. I have a Form created from tbl_Core called
"frm_Core", and the Option Group sets ups nicely. These store the values in
tbl_Core as 1,2,3. OK, works fine.

I have another Table called "tbl_Summary." I created a form,

"frm_Summary", from a Query (qry_Summary) built on tbl_Core. The Recorder
Evaluation field in frm_Summary shows "1 or 2 or 3". Works OK.

Problem: In frm_Summary, I can't use "1,2,3" -- it has to be "U,NE,E".

Also, I would like to return those same text values to a (new) text field in
tbl_Core...let's call it, "Evaluation Value Conversion". I'll use those
values elsewhere too.

I can create an Immediate f (unbound) text box in frm_Core, and it works fine.
FYI: IIf([Recorder Evaluation]=1,"U",IIf([Recorder

Evaluation]=2,"NE",IIf[Recorder Evaluation]=3,"E")))

Does the trick...but only for the unbound text box on frm_Core. The

calculated expression above occurs in the ControlSource property of that
box. I understand that an unbound box cannot pass its value back to a table.

But that's what I need to do! I would want to store "U,NE,NE" in Recorder

Evaluation, but since that's a Number control, no dice. So if that doesn't
work, then I could store it in Evaluation Value Conversion (text field) in
tbl_Core. But how? Nothing I've tried (macros, even expressions, etc.)
works.

If I can get "U,NE,E" SOMEWHERE in tbl_Core, then I can use that field to

pass the U,NE,E values to frm_Summary and everywhere else I may need them
(short of resorting to a combo box, which is not what the client wants).

 

[Jane Wilson]

can u give be advices on how I can Convert Japanese text into english text
or infact any text written in anther launage thankyou jane