Option Group Question

[Mark]

I have a form with an option group with 5 choices available. The
fieldname/control source where this info will be stored is BusUnit:

All 1
GC 2
GSP 3
GT 4
SPX 5

As I am sure you already know the value that is saved in my table is the
numeric value noted above. That means little to the user. I want the
corresponding text value to be saved in my table instead, and I want my
default text value to be "All". Note: within my option group, 1 is the
default as defined when created using the Wizard. So when a new record is
being populated or created the default value is "All" unless you select any
other option 2 through 5 above.

Thanks

Mark

 

[Jeff Boyce]

Mark

One of the beauties of a relational database (e.g., Access) is that what the
users see on forms and reports does NOT have to be stored in the tables. If
we were talking about spreadsheets, then yes, it would have to be.

A suggestion, don't you or your users work directly in the tables. Instead,
work via forms. If you do that, then the option group value stored (1-5)
will cause the correct option group choice to show up when the record is
loaded.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J. Steele]

Create a table that has the 5 values and their text equivalent, then create
a query that joins that table to your existing table, choosing all of the
fields from your existing table and the text field from the new table.

Use that new query instead of your table.