Pull down menu limitation

G

Gilles Desjardins

Hi everyone,

Is there a way to circumvent the 50 character limit when typing different
choices of a pull down menu, that one uses in a form.

TIA

Gilles
 
J

Jay Freedman

The dropdown form field has absolute limits of 25 items and 50
characters per item. The workaround you seek is the same as the one to
get around the 25-item limit: Make a userform and put a listbox or
combobox on it. See http://support.microsoft.com/?kbid=306258 for
instructions.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
 
G

Gilles Desjardins

Thank you Jay for the quick response.

Gilles
Jay Freedman said:
The dropdown form field has absolute limits of 25 items and 50
characters per item. The workaround you seek is the same as the one to
get around the 25-item limit: Make a userform and put a listbox or
combobox on it. See http://support.microsoft.com/?kbid=306258 for
instructions.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top