"MatchEntry" propery for list.

[Ed]

This is (accurate) description of the function of the MatchEntry property
for a ComboBox control.

"The control searches the column identified by TextColumn for an entry that
matches the user's typed entry. Upon finding a match, the row containing the
match is selected, the contents of the column are displayed, and the
contents of its BoundColumn property become the value of the control. If the
match is unambiguous, finding the match initiates the Click event."

Here is the problem. I have a 5 character name that will be found in the
list. VBA determines an unambiguous match after 2 letters, but I (because I
am on autopilot and typically type all 5 characters) keep on typing the
other 3. Those 3 letters (irritatingly) appear in my document since the
Click event was triggered after the first 2 letters.

Is there anyway to suppress the Click event upon an unambiguous match, but
still have the function of the search?

Ed (in Virginia)

 

[Cindy M.]

Hi Ed,

I take it this is a UserForm control? In a Userform, or in the document?

A Userform Combobox has a Click event that you can trap. If you do that, and
don't perform any action, then I'd think the information wouldn't be entered
into the document?

This is (accurate) description of the function of the MatchEntry property
for a ComboBox control.

"The control searches the column identified by TextColumn for an entry that
matches the user's typed entry. Upon finding a match, the row containing the
match is selected, the contents of the column are displayed, and the
contents of its BoundColumn property become the value of the control. If the
match is unambiguous, finding the match initiates the Click event."

Here is the problem. I have a 5 character name that will be found in the
list. VBA determines an unambiguous match after 2 letters, but I (because I
am on autopilot and typically type all 5 characters) keep on typing the
other 3. Those 3 letters (irritatingly) appear in my document since the
Click event was triggered after the first 2 letters.

Is there anyway to suppress the Click event upon an unambiguous match, but
still have the function of the search?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail