OptionGroup Object [Access 2003 VBA Language Reference]


An option group on a form or report displays a limited set of alternatives. An option group makes selecting a value easy since you can just click the value you want. Only one option in an option group can be selected at a time.

An option group consists of a group frame and a set of check boxes, toggle buttons, or option buttons.

Note  This control should not be confused with the Dynamic HTML option group control used on a data access page. For information about a option group control on a data access page, see Option Group Control (Data Access Pages).

Using the OptionGroup object

If an option group is bound to a field, only the group frame itself is bound to the field, not the check boxes, toggle buttons, or option buttons inside the frame. Instead of setting the ControlSource property for each control in the option group, you set the OptionValue property of each check box, toggle button, or option button to a number that's meaningful for the field to which the group frame is bound. When you select an option in an option group, Microsoft Access sets the value of the field to which the option group is bound to the value of the selected option's OptionValue property.

Note  The OptionValue property is set to a number because the value of an option group can only be a number, not text. Microsoft Access stores this number in the underlying table. In the preceding example, if you want to display the name of the shipper instead of a number in the Orders table, you can create a separate table called Shippers that stores shipper names, and then make the ShipVia field in the Orders table a Lookup field that looks up data in the Shippers table.

An option group can also be set to an expression, or it can be unbound. You can use an unbound option group in a custom dialog box to accept user input and then carry out an action based on that input.

Properties | AddColon Property | AfterUpdate Property | AutoLabel Property | BackColor Property | BackStyle Property | BeforeUpdate Property | BorderColor Property | BorderStyle Property | BorderWidth Property | ColumnHidden Property | ColumnOrder Property | ColumnWidth Property | Controls Property | ControlSource Property | ControlTipText Property | ControlType Property | DefaultValue Property | DisplayWhen Property | Enabled Property | EventProcPrefix Property | Height Property | HelpContextId Property | HideDuplicates Property | InSelection Property | IsVisible Property | LabelAlign Property | LabelX Property | LabelY Property | Left Property | Locked Property | Name Property | OldBorderStyle Property | OldValue Property | OnClick Property | OnDblClick Property | OnEnter Property | OnExit Property | OnMouseDown Property | OnMouseMove Property | OnMouseUp Property | Properties Property | Section Property | ShortcutMenuBar Property | SpecialEffect Property | StatusBarText Property | TabIndex Property | TabStop Property | Tag Property | Top Property | ValidationRule Property | ValidationText Property | Value Property | Visible Property | Width Property

Methods | Move Method | Requery Method | SetFocus Method | SizeToFit Method | Undo Method

Events | AfterUpdate Event | BeforeUpdate Event | Click Event | DblClick Event | Enter Event | Exit Event | MouseDown Event | MouseMove Event | MouseUp Event

Parent Objects

Child Objects | Properties Object