?MS WORD how can I auto select text in a drop down box based on first few letters?

I have a VISUAL STUDIO 2010 solution that populates WORD documents using mail merge.

Some of the fields require user in put.
One of the fields has a limited selection of choices - it seems like a drop down box is the correct control to use.

I would like to have the user be able to TAB into the field; type a few letters and the correct selection would be made.

But,
It appears that they must use the mouse.

is there a way to have an auto-text "like" selection made?

thanks
Phil -
this is Office 2010 x86; word 2010; windows 7 x64;
LVL 1
philkryderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
It isn't clear what type of dropdown you are using, but if you don't have to support anything earlier than 2007, use a Content Control.

The tab key normally inserts a tab character at the selection point. If you use Forms protection, the user will not be able to enter text that is not in a control, and the tab key will move the selection point between controls.
0
philkryderAuthor Commented:
for other reasons, we do not use Forms protection. the users may need to modify text. What we provide is more of a "suggestion."
I am using (per the tool tip) a
Drop Down List Content Control.
The tab key does move between [sic] among the controls.
But when we type the first few letters, the selection is not auto-selected.
0
GrahamSkanRetiredCommented:
It may be because I am using 2007, but in my experiments, I can't find any way to type in a few letters to locate an item, however I have arrived at the control - tab or mouse click,

In fact the only way that I can see the list of items is to click the mouse to the dropdown arrow. And then only the first letter typed selects the item. A second letter will select an item beginning with that letter.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Saqib Husain, SyedEngineerCommented:
Can you upload a sample word file (possibly fake) for experimentation?
0
aikimarkCommented:
did you set the autocompletemode for the combobox?
C# Example:
cboUserChoice.AutoCompleteMode = AutoCompleteMode.SuggestAppend;

Open in new window


reference:
http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.autocompletemode.aspx
0
GrahamSkanRetiredCommented:
I don't think that you can put .Net controls on a Word document.

I wouldn't recommend it, but it is possible to use ActiveX controls. The required behaviour for the combo box is determined by the .Style property.

ComboBox1.Style = fmStyleDropDownCombo
0
philkryderAuthor Commented:
any help on this?
As noted above, I'm not using a combo box
and
this is in WORD 2010 not a Visual Studio dot net form.

Is there a way to make auto complete work in an MS WORD 2010 Drop Down List Content Control?

thanks
Phil
0
Saqib Husain, SyedEngineerCommented:
How about a sample of your file?
0
GrahamSkanRetiredCommented:
The Drop Down Content Control is simply not designed to do this.

If you want this functionality to be a necessary feature of creating a docoumnt, I suggest that you have a Userform in which the user can enter this and any other essential information.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
philkryderAuthor Commented:
from ssaquibh
>> How about a sample of your file?

I'd rather not share that. As I noted, it doesn't work.

Can you provide a very simple word doc that shows auto complete on a Drop Down List Content Control?
0
philkryderAuthor Commented:
GrahamSkan
>>I suggest that you have a Userform in which the user can enter this and any other essential information.

? what is a USERFORM and how do I make one?
Do they work with Word Mail Merge to fill in other fields after we get the user input?
0
GrahamSkanRetiredCommented:
ActiveX controls have generic scope in that they are designed to be used on any Windows Form.

Office documents, though not Windows Forms, have been adapted to accept ActiveX controls. However they have some disadvantages and are generally not recommended. In Word, where printing is the end goal, they do not print well.

They are, however, well-adapted to be used with VBA code and UserForms are Windows forms that come as part of the VBA package. They need to be designed and appropriate VBA code written.

It is possible to design such a form with several ActiveX controls which would open when a new document is created from your template. There would be a button to cause the entered data to be loaded on the document and to close the form.

It would also be possible, but not entirely straightforward to use them when Word Mail Merge is run to open for each record in the Datasource.

It isn't entirely clear how you want to use Content Controls in conjunction with Mail Merge. The built-in way to collect data from the user during a mail merge run is by using ASK or FILLIN fields.
0
philkryderAuthor Commented:
>>It isn't entirely clear how you want to use Content Controls in conjunction with Mail Merge. The built-in way to collect data from the user during a mail merge run is by using ASK or FILLIN fields.

Many items are filled in by mail merge from a web page into a CSV that is then used to do the mail merge.

After the mail merge is done,
the user can make further customizations, such as making selections in the drop down box.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.