option group and keyboard input

[sparks]

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]

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

--
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.

"sparks" <js******@swbel l.net> wrote in message
news:hf******** *************** *********@4ax.c om...

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.

[sparks]

On Mon, 5 Jun 2006 20:24:31 +0800, "Allen Browne"
<Al*********@Se eSig.Invalid> wrote:

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

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]

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.

--
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.

"sparks" <js******@swbel l.net> wrote in message
news:rv******** *************** *********@4ax.c om...

On Mon, 5 Jun 2006 20:24:31 +0800, "Allen Browne"
<Al*********@Se eSig.Invalid> wrote:

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

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]

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.

On Mon, 5 Jun 2006 20:56:20 +0800, "Allen Browne"
<Al*********@Se eSig.Invalid> wrote:

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.

[Allen Browne]

Think I'd be replacing the option group with a combo (or list box.)

--
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.

"sparks" <js******@swbel l.net> wrote in message
news:26******** *************** *********@4ax.c om...

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.

On Mon, 5 Jun 2006 20:56:20 +0800, "Allen Browne"
<Al*********@Se eSig.Invalid> wrote:

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.

[sparks]

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.

On Mon, 5 Jun 2006 22:32:32 +0800, "Allen Browne"
<Al*********@Se eSig.Invalid> wrote:

Think I'd be replacing the option group with a combo (or list box.)

[pietlinden]

sparks wrote:

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.

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?)