Word Forms help

[Tom L]

Is there a way to increase the number of entries allowed in
a drop down box when you have a drop down box in a form? I think the default is 25.
Thanks

[ileacy]

Hi Tom.
I am going to move this thread to the Word forum.

[chrisgreaves]

Eh?

[ileacy]

This message was initially posted on the General Office Solutions board. It was moved to the Word Board.

[chrisgreaves]

Ah!

[Gary Frieder]

Hi Tom,

The 25 limit sounds familiar. That limit is probably a good thing, as trying to scroll down a longer list can get trying.

The simplest alternative to implement is, if possible, to break down the list into subcategories and have a separate dropdown for each sublist.

Higher up on the complication scale, but potentially more elegant, is to have a userform (custom-built dialog box) rather than a form. With a userform you could, for instance, have option buttons representing the names of the different subcategories; whichever option button is selected, its associated sublist could be displayed in the drop down.

Gary

[gwhitfield]

Or else have a look at <A target="_blank" HREF=http://www.woodyswatch.com/office/archtemplate.asp?v6-n09>Woody's solution</A>

[Tom L]

Gary, thanks but i'm not at the user form level yet. I
think I am going to try Geoff W's solution.

[Tom L]

Geoff, thanks i followed the link and copied the solution
from Woody's Watch. I think it will solve my problem.