How do I create an option group in table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created an option group with three choices in form design view; the option
group is not shown in the table view. I did create a check box in table
design for that field. Please help me create the option group to display in
both form and table views.

Thank you in advance,
hrman
 
You can't in table-view. Table view displays the records in a TABLE VIEW.
How could you show an option group (a box) in a TABLE VIEW?
 
I created an option group with three choices in form design view; the option
group is not shown in the table view. I did create a check box in table
design for that field. Please help me create the option group to display in
both form and table views.

Thank you in advance,
hrman
Click to expand...

Change that check box field in the table to Number datatype, field
size Integer.
On the form, make that field the Control source for the Option Group.
The Table field will store the selected value of the group as a number
value.

You can display the number value as text, in a report for instance,
using an unbound control. Set it's control source to:
=Choose([OptionField],"Text1","Text2","Text3") etc.
 
I created an option group with three choices in form design view; the option
group is not shown in the table view. I did create a check box in table
design for that field. Please help me create the option group to display in
both form and table views.
Click to expand...

You cannot.

Table datasheets are of VERY limited utility. They are not designed as
data entry or editing tools. In particular, table datasheets do not
allow the use of Option Group controls for display.

A Table is a data *storage* object. A form is a data *display* object.
They are different kinds of objects, for different purposes.

John W. Vinson[MVP]
 
Back
Top