Option groups in Microsoft Access forms are a set of controls that allow users to select from a limited number of choices. They are typically used when a user needs to choose one option from several distinct alternatives. An option group is visually represented by a frame containing options, which can be check boxes, toggle buttons, or option buttons. Only one option within an option group can be selected at a time, making it an ideal choice for mutually exclusive selections. When an option is selected, Access sets the value of a bound field to the value of the selected option's `OptionValue` property, which is a number. This number is then stored in the underlying table. Option groups can be bound to a field, unbound, or calculated based on an expression. They are particularly useful in scenarios where the input needs to be restricted to a set of predefined choices, ensuring data integrity and consistency. For example, an option group could be used on a customer feedback form to rate service quality, with options ranging from 'Poor' to 'Excellent'. The simplicity of option groups makes them a powerful tool for form design in Access, streamlining data entry and minimizing user error.
Microsoft Access tutorial
#msaccess
#access