Drop down list size in a form

[Joanne]

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.

 

[Jay Freedman]

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
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Joanne]

Thank you so much! You are probably a genius.

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
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.