>You can hot-key the labels of the option buttons in the option group.
>
[quoted text clipped - 3 lines]
> [o] &Walnut
> [o] Wa&termelon
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?)