Originally Posted by
DDEB
...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!
Originally Posted by
DDEB
...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).
Originally Posted by
DDEB
...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:
Code:
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)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007