Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / June 2006

Tip: Looking for answers? Try searching our database.

option group and keyboard input

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sparks - 05 Jun 2006 12:50 GMT
When you enter an option group you can move to each option with the
arrow keys and select with the space bar.
Option groups don't have keydown events so has
anyone come up with a way to allow keyboard entry for
option groups?

Just a simple way to select with 1-5 from the keypad or some such.

thanks for any help or a link to what to read.

Jerry
Allen Browne - 05 Jun 2006 13:24 GMT
You can hot-key the labels of the option buttons in the option group.

Just add an ampersand before the hotkey letter, e.g.:
   [o]    &Apple
   [o]    &Banana
   [o]    &Walnut
   [o]    Wa&termelon

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> When you enter an option group you can move to each option with the
> arrow keys and select with the space bar.
[quoted text clipped - 3 lines]
>
> Just a simple way to select with 1-5 from the keypad or some such.
sparks - 05 Jun 2006 13:52 GMT
>You can hot-key the labels of the option buttons in the option group.
>
[quoted text clipped - 3 lines]
>    [o]    &Walnut
>    [o]    Wa&termelon

thanks that does work on the ones with
a caption or 1 and an option value of 1

what if you have something like  a caption of "less"
and an option value of 1
you could have &less and allow the "L" key for input
but not a  &1 for the option value. If you want to make it
so that a 1 would put in less

again thanks this is simple..

now I have 200 option groups I need to go fix   :)

humm a little code to change that should be simple

sparks
Allen Browne - 05 Jun 2006 13:56 GMT
Actually, it does work.

You can set up your option group like this:
   [o]    &1. Apple
   [o]    &2. Banana
   [o]    &3. Walnut
   [o]    &4. Watermelon
and then choose Walnut with Alt+3.

Of couse, we are assuming that you did set up the OptionValue of the option
button to match the hotkey of the attached label.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>>You can hot-key the labels of the option buttons in the option group.
>>
[quoted text clipped - 18 lines]
>
> humm a little code to change that should be simple
sparks - 05 Jun 2006 15:01 GMT
No I inheritated this mess   LOL

they have something like 500 option groups in this database.
I can fix all but one page with just a little code ....THANKS TO YOU
the one page has
less somewhat more
as the three options
and they want 1 2 3 for inputs.

>Actually, it does work.
>
[quoted text clipped - 7 lines]
>Of couse, we are assuming that you did set up the OptionValue of the option
>button to match the hotkey of the attached label.
Allen Browne - 05 Jun 2006 15:32 GMT
Think I'd be replacing the option group with a combo (or list box.)

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> No I inheritated this mess   LOL
>
[quoted text clipped - 17 lines]
>>option
>>button to match the hotkey of the attached label.
sparks - 05 Jun 2006 15:53 GMT
Even better I told them the forms were NOT for data collection but
just for data entry. I suggested a text box...
BUT they don't match the forms.(whine)
WTF does that have to do with it.
But if we are looking for something its easier to find..
huh

man you can't win...seems that the ones that do NO data colleciton
or entry or anything else are in change of how its done.  

>Think I'd be replacing the option group with a combo (or list box.)
pietlinden@hotmail.com - 06 Jun 2006 06:24 GMT
> Even better I told them the forms were NOT for data collection but
> just for data entry. I suggested a text box...
[quoted text clipped - 5 lines]
> man you can't win...seems that the ones that do NO data colleciton
> or entry or anything else are in change of how its done.

That's most of the "fun" with design - dealing with people that know
nothing about databases... Sometimes you just have to train them...
They just want to do everything the way they always have, even if it
isn't very good.  (Do cattle prods work well in this case?)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.