Ok stupid Q time....

[evilcowstare via AccessMonster.com]

I know this is probably a very simple thing to do but I cannot find how to
change it..

In my form I have set up tab stops, they go all the way through...

What I want to do is when the tab stops at a drop-down box the user can then
use the up and down arrows to look through it, then press enter to select the
one they have highlighted. At the moment when you use up or down it moves
forward or back to the tab stops.

I have been looking for the solution but have yet to find it although I know
in the past I have set it up before on previous forms long gone.

Thank You

 

[Joan Wild]

You can use the On Enter property to

ComboName.DropDown

or since your users appear to know (or you are training them) in using the
keyboard, tell them about F4 which will dropdown any combobox - it's a
Windows standard.

 

[evilcowstare via AccessMonster.com]

Hi Joan, thank you.
Just as I suspected I feel stupid lol.

I'll be honest though I have been using PCs for years and really never knew
that F4 dropped down combos, thanks for the tip, guess it was something i
never tried :-/

Thanks

You can use the On Enter property to

ComboName.DropDown

or since your users appear to know (or you are training them) in using the
keyboard, tell them about F4 which will dropdown any combobox - it's a
Windows standard.

I know this is probably a very simple thing to do but I cannot find how to
change it..

[quoted text clipped - 13 lines]

Thank You

 

[Al Campagna]

Evil,
The proper sequence for combo slection is...
Upon entry hit F4 to expand thge dropdown, then use up and down arrows to navigate to
the correct selection.
I think your using Up/Dn arrows while in the field... without having expanded the combo
first... causing a navigate to the next/previous field.
You can also use the OnEnter to...
cboXYZ.DropDown
to automatically expand the combo upon entry. Then... the user can Up/Dn.
I would rather educate the users to the "proper" combo editing method, but... that code
would allow them to continue with what they have been used to.
Your call...

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[evilcowstare via AccessMonster.com]

Hi Al

Thanks very much for the info, the people its designed for arn't that hot on
remembering short cuts so im trying to make it as automated as possible, the
Drop.Down code will do this fab.

Thanks

Evil,
The proper sequence for combo slection is...
Upon entry hit F4 to expand thge dropdown, then use up and down arrows to navigate to
the correct selection.
I think your using Up/Dn arrows while in the field... without having expanded the combo
first... causing a navigate to the next/previous field.
You can also use the OnEnter to...
cboXYZ.DropDown
to automatically expand the combo upon entry. Then... the user can Up/Dn.
I would rather educate the users to the "proper" combo editing method, but... that code
would allow them to continue with what they have been used to.
Your call...

I know this is probably a very simple thing to do but I cannot find how to
change it..

[quoted text clipped - 10 lines]

Thank You

 

[fredg]

I know this is probably a very simple thing to do but I cannot find how to
change it..

In my form I have set up tab stops, they go all the way through...

What I want to do is when the tab stops at a drop-down box the user can then
use the up and down arrows to look through it, then press enter to select the
one they have highlighted. At the moment when you use up or down it moves
forward or back to the tab stops.

I have been looking for the solution but have yet to find it although I know
in the past I have set it up before on previous forms long gone.

Thank You

I think this is what you mean.

Code the combo box Enter event:
Me.[ComboName].Dropdown

As soon as you tab into the control it will drop-down.
Use the down or up arrow until you make your selection. Then press
Enter or the Tab key to select that item and exit the combo box.

 

[John W. Vinson]

I'll be honest though I have been using PCs for years and really never knew
that F4 dropped down combos, thanks for the tip, guess it was something i
never tried :-/

hmmmm...

Me neither!

Thanks Joan!

John W. Vinson [MVP]

 

[Joan Wild]

hmmmm...

Me neither!

Thanks Joan!

Actually a lot of the keyboard methods used in Access work in Windows
generally...
tab, shift-tab, spacebar to toggle a checkbox, arrow keys to select options
in a group, etc

I use them all the time on web pages, Start...Search, Windows Explorer, etc.

 

[Keith Wilby]

hmmmm...

Me neither!

Thanks Joan!

I didn't know that either but it doesn't appear to work in MS Project.

Keith.