Make down arrow go down the list

[prana1]

Hi all,
I just made a decent, simple form. It will allow me to enter invoices.

I have a field that has long 10-digit numbers in it, and I would like to be
able to scroll down that list when I am in that field. Right now, I press 2
and the first number that starts with 2 comes up, but I want a different one.


I would like the "behaviour" of the form to be as such, so when I press the
down arrow, it scrolls down that combo list. Instead, it just goes to the
next field.

I tried making a macro, calling it scroll_down, and chose some things like
'find next', but that did not work.

 

[SusanV]

Press the alt key when you hit the down or up arrow the first time to expand
the list, then the arrow keys will behave as desired.

 

[prana1]

Hm, didn't work. Here's some more info:

Combo list comes from the table named GL with the following:

159004
245747-1234
245747-5678
245747-7890

plus a pri. key. When I made this, I sorted it, then made the form.

I realized when I pressed '2' in the appropriate field, the first one that
matched would come up.

I want this order to change on the form, so when I type the number 2, I get
a match right away, which is really the 4th element on my list (245747-7890).
Otherwise I have to type 245747-7 to exclude the rest and get a match on the
one I want.

I tried unsorting this in the table, and it looks fine there, the
245747-7890 is the second record.

But in the form I went to record - unsort, but it did make a difference,
they still stay in that old sort.

Since I am not doing this in full screen mode, when I pressed Alt., the word
"File", gets highlighted, from the top menu bar.

 

[SusanV]

Not sure what you mean by the sorting stuff, it's somewhat irrelevant to the
original issue - however, sorting in tables won't do much for you in forms
or reports - you should do your sorting on the form itself. Not sure what
you mean by "full screen mode" either?

Anyways if the combobox has focus (tab to it, click in it, whatever) then
holding alt WHILE pressing up or down will expand the dropdown, and once
it's expanded, the arrow keys will move the focus within the list. If you
press alt THEN the down arrow you will activate the File Menu.

 

[Ken Snell \(MVP\)]

Scrolling through a combo box list works only when the dropdown list is
showing. This is by design in ACCESS.

I have created a combination combo box / spin buttons setup on a form that
will allow you to click on up / down arrow buttons on the form and have the
combo box scroll without showing the dropdown list. See
http://www.cadellsoftware.org/SampleDBs.htm#Cbospin for a sample database.

 

[prana1]

Ahh, pressing Alt+down, that did it.

Thanks!

Not sure what you mean by the sorting stuff, it's somewhat irrelevant to the
original issue - however, sorting in tables won't do much for you in forms
or reports - you should do your sorting on the form itself. Not sure what
you mean by "full screen mode" either?

Anyways if the combobox has focus (tab to it, click in it, whatever) then
holding alt WHILE pressing up or down will expand the dropdown, and once
it's expanded, the arrow keys will move the focus within the list. If you
press alt THEN the down arrow you will activate the File Menu.

 

[SusanV]

Glad to help

Ahh, pressing Alt+down, that did it.

Thanks!