Pull down menu limitation

  • Thread starter Thread starter Gilles Desjardins
  • Start date Start date
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
 
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.
 
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.
Click to expand...
 
Back
Top