By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

SelStart - SelLength

P: n/a
Hello,
There are many threads on this subject but I can't find the
answer for my particular situation in Access 2000. I have a populated
combo box that my users would like to work as a "Smart Search". In
other words, they want to start typing the entry they are after and
have the combo box search down matching, not only the first letter, but
all succesive letters.
EXAMPLE: "B", "U", "L" separates "Bull Moose" from "Buckeye"

This works in two cases:
Case 1: If they click the down arrow on the combo box, it drops
down, and they can start typing until reaching the desired entry and
then hit enter.
Case 2: If they tab into the combo box, the entire line is
highlighted so they can start typeing as in case 1:

This does not work:
Clicking on the combo box (Not the drop down) arrow. I tried
using the Enter and/or GotFocus events to force highlighting the entire
entry with:
Me.VendorCombo.SelStart = 0
Me.VendorCombo.SelLength = 100
But no highlighting takes place so any keystrokes just end up
in the current text.
Thanks,
Hank Reed

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

In an older A97 app I did, I have a first combo box that has focus when
the form opens, the enduser can just start typing a name and it will
search down the list as you wanted - all I used was the keypress event:

Private Sub cboFindEE_KeyPress(KeyAscii As Integer)
Me!cboFindEE.Dropdown
End Sub

works like a charm.

JimA

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.