Option Group

[Guest]

I create an Option Group Frame 159 (Control Source: Loc)with three values:
The option Group on the form is displays ED, EU, EZ. However, when this
saves to the table (which is a Text Field) it only stores 1, 2, or 3. I need
it to Store ED, EU, or EZ. How can I do this?

 

[Duane Hookom]

This is a reports news group which isn't quite appropriate for a forms
question. However, an option group always has numeric values. I would change
the field type to numeric. When ever you need to display ED, EU,... you can
lookup up the value in a small table or use an expression like:
=Choose([FieldName],"ED","EU","EZ")