"MatchEntry" propery for list.   

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)

date: Fri, 10 Oct 2008 06:02:57 -0400   author:   Ed

Re: "MatchEntry" propery for list.   

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 :-)

date: Mon, 27 Oct 2008 11:15:41 +0100   author:   Cindy M.