Using Radio Buttons on a Form

[DDEB]

I have a table with a few columns that have data added by a lookup field. This isn't pulling information from another table or anything it's a simple list of choices. Lookup properties example:
Display Control: Combo Box
Row Source Type: Value List
Row Source: 0;5

When I create a form based on this table my options are displayed with a drop down menu, however I would like it to be displayed using radio buttons. Is there any easy way to change the format from drop down menu to radio buttons (options)? I know I can do this using option groups and setting each up individually but I have about 20 columns so it'll take me quite a long time.

Any suggestions would be appreciated!

[June7]

I doubt it can be any faster than building one then using copy/paste and editing properties of the copies.

[Missinglinq]

...When I create a form based on this table my options are displayed with a drop down menu, however I would like it to be displayed using radio buttons.

Not to be unkind, but you really should have spent a little time learning how Access works as well as planning how you wanted your database to work. You simply cannot jump in, feet first, and hope for the best, and I'm afraid you're going to have to pay the piper for that, to get what you want!

...Is there any easy way to change the format from drop down menu to radio buttons

No. A Radio Button, for instance, cannot be used to display arbitrary data. Basically their Values are True/Yes (-1) or False/No (0).

...I have about 20 columns so it'll take me quite a long time.

Then you'd better get started! The only way to set up twenty Controls to do their own thing is to to set up twenty Controls to do their own thing!

And keep in mind what I said above; Radio Buttons have Values of Yes/No which literally is 0/-1. If you want this to equal, say, 5 or 10, you would have to

• Create a Field to hold the Data of 5 or 10
• Set the AfterUpdate event of the Radio Button to assign the Value to it depending on the Value of the Button.

The second item above could be done using something like this:

Private Sub YourRadioButton_AfterUpdate()
 If Me.YourRadioButton = -1 Then
  Me.TagetField = 5
 Else
  Me.TagetField = 10
 End If
End Sub

Using Radio Buttons with an Option Group at least allows you to directly assign a Numeric Value to each choice, through the Wizard, as long as it is an Integer (whole number). The Control, in an Option Group, is the Option Frame itself, not each individual Radio Button.

And just to re-iterate what you've apparently figured out, here, Comboboxes have their uses, but they are overkill when you are using them to offer one of two possible Values!

Linq ;0)>