Others

Add a Radio Button to an Existing Microsoft Access Option Group

Phi Hung VoPhi Hung Vo Nov 20, 2026 868 views

Question details

The user wants to add another radio button to an existing option group on an Access form.

Add a Radio Button to an Existing Access Option Group
Product
Microsoft Access
Device & OS
not provided
Scenario
An existing form option group needs an additional choice with its own value and label.
Observed behavior
The new option button should appear inside the group and have a unique option value and descriptive label.
Before you start

Open the Access database and locate the form containing the option group. Check the existing buttons' Option Value properties so you can choose a different value for the new button.

Solution 1Recommended

Add an option button in Access Design view

Use the form's Design view to place a new button inside the existing group and configure it.

1
Open the form in Design view

In the Navigation Pane, right-click the form and select Design View.

2
Add the button to the group

Select the option group by its border. On the Design tab, choose Option Button, move the pointer over the group until it is highlighted, and click where you want the new button.

3
Set the option value

Select the new button and open the Property Sheet from the Design tab if needed. On the Data tab, set Option Value to a number different from the other buttons in the group.

4
Edit the label and test

Select the button's attached label and edit its Caption in the Property Sheet. Save the form, switch to Form View, and click the new option to test it.

Add an option button in Access Design view
Check the group value: If the option group is bound to a field, selecting the new button sets the group's value to the button's Option Value.
Free Microsoft Office alternative

Use WPS Office for everyday document and spreadsheet work

WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents. It can help you migrate common document and spreadsheet tasks, but it does not edit Microsoft Access option groups or replace Access for this form change.

Free, lightweight tools for everyday office workCompatible with Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXFamiliar menus make it easier to move common Office tasks to WPSKeep using Access for database forms and option groups
microsoft office alternative - wps office

Frequently Asked Questions

How can I tell whether the new button belongs to the option group?

In Design View, move the Option Button pointer over the group and wait for the group to highlight before clicking. Then switch to Form View and check that selecting the new button clears the other selection in the group.

What should I enter for the new button's Option Value?

Select the button in Design View and open Property Sheet > Data > Option Value. Enter a number that is different from the values assigned to the group's other buttons.

How do I change the text beside the radio button?

In Design View, select the button's attached label, open the Property Sheet, and change its Caption.

Can I copy an existing option button instead?

Yes. In Design View, copy an existing option button and paste it into the group. Then check that it belongs to the group, give it a unique Option Value, and edit its label.