MS Access Option Groups - How to Use Radio Buttons

[@endsleighplace]

Interesting and well paced. I wish that passing the value to the database was covered, though. I realize that for an experienced Access-user it is probably obvious, but I'm just starting out unfortunately.

[@seanmackenziedataengineering]

Good question and thanks for the feedback. For option groups, you will open the properties of the Option Group and set the Control Source to the desired field of the table/query that the form is bound to. Some people will try to set the control source to the radio buttons instead, which will not work. If your form does not have a RecordSource, you can set it to a table in the Form's properties. Then it will be available to choose for the Option Group.

[@kyleoliver8142]

Thanks for the vid info Sean, much appreciated. I am very new to MS Access. With all the "Yes" / "No" radio buttons on my form, is there a way to reflect the selected value of either "Yes" or "No" in the Access database cause when I select the "Yes" the database shows the number "1" but does not show "Yes"?

[@seanmackenziedataengineering]

Welcome to the world of Access! An option group will give you 1 for yes and 2 for no in this scenario. If you go to your table in design, click on the field, then Lookup. Set display values to Combo Box, then row source type to Value List and row source to 1;"Yes";2;"No" and column count = 2. It will still store 1 or 2 but is an easy way to see Yes or No when you look at the table. Optionally, try using a Checkbox for Yes/No

[@kyleoliver8142]

@@seanmackenziedataengineering Thanks Sean, I got it!!

[@seanmackenziedataengineering]

@@kyleoliver8142 Nice!

[@venkatyalamati3285]

Thank you so much for the tutorial!!!

[@seanmackenziedataengineering]

Glad it worked for you! Cheers

[@jorgecollazos2004]

Muchas gracias, excelente video.

[@seanmackenziedataengineering]

Bienvenido!

[@jdlv1250]

Thank you for the video. How can we convert those numeric options to text? I have been trying with this after update coding but it’ does not work. Select Case Me! [frameX] Case 1 Me! [textValues] = “Green” Case 2 ......

[@seanmackenziedataengineering]

Your example code looks good. If you put it in the "after update" event, it should work! Do you get an error? Also, make sure that you dropped the "options" radio buttons onto the frame as it turned black, when you hovered over it to drop the option on there.

[@txujcihmoob88]

How can I build to show the column of datasheet is the color after update, do not show the number but show the color instead

[@seanmackenziedataengineering]

One trick you can use is to set the forecolor and backcolor of the cell to the same color. You can also use conditional formatting for this.

[@txujcihmoob88]

@@seanmackenziedataengineering Please could you make sample and show how it works

[@davidparry9701]

I can get an option group to update the criteria in a query using your technique in this video. Great job in explaining. But I need to go one step further so that the query finds all options. If I leave the criteria field blank, then the query finds all options, but I can't figure out how to make it work so that all options or any one option is returned by the query. Any advise on how to tackle this? Warm regards and many thanks for your great videos.

[@seanmackenziedataengineering]

Good question! For this you can make use of something like you see at 11:30, where you'll set your filter or querydef in the After Update event of the form. Something like: If IsNull(Me!ogrpMain) Then CurrentDb.QueryDefs("MyQuery").SQL = "Select * From MyTable" Else CurrentDb.QueryDefs("MyQuery").SQL = "Select * From MyTable Where MyField = " & Me!ogrpMain End If If you are actually filtering on the same form, you can set the Filter property: If IsNull(Me!ogrpMain) Then Me.Filter = "" Me.FilterOn = False Else Me.Filter = "MyField = " & Me!ogrpMain Me.FilterOn = True End If

[@ariesmahal]

Make video on continuous form multiple record enter with one button

[@seanmackenziedataengineering]

Great suggestion, thanks!

[@larrywelch9359]

Good evening Sean; just started watching your video(s). I would like to know if you have a video that shows how a textbox (on a form, continuous form or subform) can grow/shrink (to only show the numbers of characters in the textbox). I know that a textbox on a Report will grow/shrink, depending on the number of characters in the textbox. I have found several VBA Code(s) that help but does not force the textbox to grow/shrink. Any help in this would be greatly appreciated.

[@seanmackenziedataengineering]

That's a great idea for a video! I don't think I have ever seen this implemented, but I have seen several solutions that use multiple sizes of unbound text boxes with a condition; ie. Show txt1 if this many characters, txt2 if this many and so on. The CanGrow property on Reports sure is handy! Cheers

[@digvijaygujale9433]

Awesome !!! Can you please create video on multithreadig. With CsV file.?

[@seanmackenziedataengineering]

VBA subs/functions run only on a single thread, so this might be a challenge!

[@digvijaygujale9433]

@@seanmackenziedataengineering with Python i am asking for.

[@seanmackenziedataengineering]

I see! Ok, this will be interesting.. I will add this topic to my list. Stay tuned!

[@sajiidkhan6100]

Many thanks and appreciate your time and wonderful mentoring session,I have question, how can I use toggle button more than time in one option group frame. What I say, I have x ,y and z with the same toggle button see example ,xy units(label) in table: feet or meter and have field in the same table (zunits) feet or meter . So, I need to toggle on the same unit for x,y and z(feet) but error pop up you couldn’t use the same value more than time.

[@seanmackenziedataengineering]

Option groups are mutually exclusive and only allow one entry. You can use your toggle buttons outside of an option group for the effect you're looking for, or you could put selections in a multi-select listbox. Let me know how it goes!

[@johnw4983]

How can you use the Tab key to move from one radio button to the next in an option group?

[@seanmackenziedataengineering]

Good question! The normal behavior is to tab from another field onto the option group, use arrow keys to select, then tab off to the next field. I suppose you could program some radio buttons outside of a frame, so that you could tab between them as a selection, but that would take some coding.