Table of contents
TOC
Collapse the table of content
Expand the table of content

OptionGroup Object (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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.

Remarks

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

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 etting 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.

Events

Name
AfterUpdate
BeforeUpdate
Click
DblClick
Enter
Exit
MouseDown
MouseMove
MouseUp

Methods

Name
Move
Requery
SetFocus
SizeToFit
Undo

Properties

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

See also

Other resources

OptionGroup Object MembersAccess Object Model Reference

© 2017 Microsoft