Hello,
I have a form with a drop down list with 63 entries. I found out that the
drop down in a form will only accept 25 entries. This is really a very simple
form and I was wondering if anyone has a good workaround to get more than 25
entries into a drop down list. Thank you for any help you can provide.

Re: Drop down list size in a form by Jay

Jay
Wed Sep 05 15:42:09 CDT 2007

Joanne wrote:
> Hello,
> I have a form with a drop down list with 63 entries. I found out
> that the drop down in a form will only accept 25 entries. This is
> really a very simple form and I was wondering if anyone has a good
> workaround to get more than 25 entries into a drop down list. Thank
> you for any help you can provide.

The dropdown form field that you can put into the body of a document has an
absolute limit of 25 items, and there are no tricks to enlarge it.

The main alternative is to use a combo box in a UserForm (a custom dialog),
as described in http://support.microsoft.com/?kbid=306258. There's also an
introduction to UserForms at
http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm.

You may be tempted to use a combo box from the Control Toolbox, which is
similar to the one available for UserForms but can be placed in the document
body. I'd recommend against it, though. Look at the "Appropriateness for
Task" section of
http://msdn2.microsoft.com/en-us/library/aa140269(office.10).aspx to see
why.

--
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.



Re: Drop down list size in a form by Joanne

Joanne
Thu Sep 06 09:58:08 CDT 2007

Thank you so much! You are probably a genius.

"Jay Freedman" wrote:

> Joanne wrote:
> > Hello,
> > I have a form with a drop down list with 63 entries. I found out
> > that the drop down in a form will only accept 25 entries. This is
> > really a very simple form and I was wondering if anyone has a good
> > workaround to get more than 25 entries into a drop down list. Thank
> > you for any help you can provide.
>
> The dropdown form field that you can put into the body of a document has an
> absolute limit of 25 items, and there are no tricks to enlarge it.
>
> The main alternative is to use a combo box in a UserForm (a custom dialog),
> as described in http://support.microsoft.com/?kbid=306258. There's also an
> introduction to UserForms at
> http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm.
>
> You may be tempted to use a combo box from the Control Toolbox, which is
> similar to the one available for UserForms but can be placed in the document
> body. I'd recommend against it, though. Look at the "Appropriateness for
> Task" section of
> http://msdn2.microsoft.com/en-us/library/aa140269(office.10).aspx to see
> why.
>
> --
> 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.
>
>
>