Some formatting (controls) questions

[Gunti]

Hi,
I have a macro and have got some questions to ask about some formatting
issues.

I've got a listbox with a bunch of names. What i basicly want is that when
you click on the listbox, press WAT for example it should come down to Water
etc. (Kind of hard to explain, i basicly want to be able to type a name to
get to that name).

Another one is that i've made a combo box -> it has a scroll bar which
doesn't work at all. When you hold it down completely, it actually jumps up
and it's at about a quarter of my data. (9000 values).

Any help on this is appreciated.

Greets,
Gunti

 

[Wayne-I-M]

I've got a listbox with a bunch of names. What i basicly want is that when

you click on the listbox, press WAT for example it should come down to Water
etc. (Kind of hard to explain, i basicly want to be able to type a name to
get to that name).

Open the form in desiegn view and change the list box to a combo.
Set the AutoExpand row to = Yes

Another one is that i've made a combo box -> it has a scroll bar which
doesn't work at all. When you hold it down completely, it actually jumps up
and it's at about a quarter of my data. (9000 values).

Thats what it's meant o do. To scroll down record by record click the up
arrow at the top of the scroll bar and the down arrow at the bottom of the
scroll bar.

HTH

 

[Gunti]

Open the form in desiegn view and change the list box to a combo.

Set the AutoExpand row to = Yes

I know this works aswell, but i want a list of names. Normally for example
(in windows explorer) there is a list. But if you type SA it goes to the
first folder or file which starts with SA. You can only do that with the
first letter in a list. Any way around this??

Thats what it's meant o do. To scroll down record by record click the up
arrow at the top of the scroll bar and the down arrow at the bottom of the
scroll bar.

I don't think you understand, the scrollbar exists of the down arrow, up
arrow & the middle bar which you can scroll with. Both arrows work fine, but
when i scroll the bar down completely it doesn't go to the lowest value
(instead, the bar jumps to the middle again and i've scrolled halfway).

About the default value ->

 

[Wayne-I-M]

You can set the combo to have a height that will show you a list ??

I don't list boxes have an auto expand function

You could biuld one by adding a text box to your form and filtering the list
box
so if you type in A you will filter the list to all starting with A

then AB you will filter the list to all starting with AB
AVC etc
etc
etc.

Seems a lot of work for something that you can do with a combo wizard

If you "really" want the module public function and the vba for the form to
call it post back and I'll send it - but whats the point ??

 

[John Spencer (MVP)]

The problem is that Access may not fully populate the combobox until you
attempt to access the rows in at the bottom of the combobox. You can force
the combobox to be fully populated by checking the listcount in the form's
Open event or the load event.

Private Sub Form_Open(Cancel As Integer)
Dim L as Long
'Force the combobox to fully populate
L = Me.ComboboxName.ListCount

End Sub


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Gunti]

Nah it shouldn't be as hard as that! Just would of thought it would be decent
looking. Thanks for the trouble anyway!