Drop down menu for 100 items & Autocomplete

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debbiedo - 28 Jun 2007 17:38 GMT

I am trying to design a protected MS Word 2003 template. Data from
this form will eventually be imported into Access. One of the fields
will be used to do a join on a look up table in Access so the
information inputted into the word document must be standardized.

I figure I will have to create a drop down list to accomplish this.
The problem is that the list has about 100 items. I would like the
user to add the first few letters and have it autocomplete the item in
the list and populate the field with this.

>From what I have read the Word drop down list option can handle only

25 items. What do I need to do to make a list of 100 items and how do
I get it to use autocomplete? This form will be on over 20 separate
computers.

Suggestions anyone? Thank you in advance.

Deb

Reply to this Message

Doug Robbins - Word MVP - 29 Jun 2007 09:35 GMT

Well, you can use the method in the Knowledge Base Article:

WD2000: How to Create Combo Box with More Than 25 Items [Q198561]
http://support.microsoft.com/support/kb/articles/Q198/5/61.ASP

but as the involves the use of a userform anyway, you may as well start and
do it right with a userform.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and take a look at:

http://www.mousetrax.com/techpage.html#autoforms

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to design a protected MS Word 2003 template. Data from
> this form will eventually be imported into Access. One of the fields
[quoted text clipped - 14 lines]
>
> Deb

Reply to this Message

Mark - 01 Aug 2007 22:57 GMT

1. could not find the link to start a new topic.
2. Started with http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
have runtime error 424: object required.
debubber stops at – UserForm1.show
Code:
Sub AutoNew()
UserForm1.Show vbModal
Unload UserForm1
Set UserForm1 = Nothing
'''
End Sub
3. purpose of program is to make labels from a avery form. Unit model and serial number are printed. I forsee many more problems before I get this to work.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Reply to this Message

Jay Freedman - 02 Aug 2007 14:47 GMT

Unfortunately, the VBA debugger always stops on the .Show statement when
there's a syntax error in the userform being called. Post the code from your
userform so we can have a look.

From experience, the problem in userforms made from that article is usually
that you've left out the required space before the line-continuation
underscores in step 10. In other words, you must type a space between the
'e' and the underscore to change

.Bookmarks("Text1").Range_

to

.Bookmarks("Text1").Range _

See http://word.mvps.org/FAQs/MacrosVBA/_AtEndOfLine.htm for explanation.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> 1. could not find the link to start a new topic.
> 2. Started with
[quoted text clipped - 14 lines]
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com

Reply to this Message

OTWarrior - 03 Sep 2007 16:53 GMT

would this help?

http://www.officekb.com/Uwe/Forum.aspx/word-program/958/form-field-drop-down-25-
limit-list-I-have-made-a-fix-of-sorts#76c655d6f15bfuwe

Reply to this Message