Drop down form field

[KMK]

It appears you can only use 50 characters in creating a drop down menu item.
Is there a way to expand the number of characters for each menu option?

 

[Jay Freedman]

It appears you can only use 50 characters in creating a drop down menu item.
Is there a way to expand the number of characters for each menu option?

The dropdown form field is absolutely limited to 25 entries of at most
50 characters each. To work around this, you need to create a userform
(custom dialog) with a listbox. See these articles:

http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm
http://support.microsoft.com/?kbid=306258

 

[Graham Mayor]

You can however *insert* more text than the dropdown will accommodate - see
http://www.gmayor.com/SelectFile.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>