Drop-Down Form Fields ???

[Guest]

I have a few questions about the use of form fields that I can not seem to find an aswer to anywhere else.
1. Is there a way to "over-ride", "work-around", or "cheat" the 25 item limit imposed on Drop-Down Form Fields" I need to have 8 selectable lists, each from 0 through 120 that will be used to identify the length of certain items. The 8 items are then SUMmed into a 9th Text Form Field. I am currently using 8 Text Form Fields, but would rather use a Drop-Down Form Field if possible

2. Is there a way to "append" or "add items to" a Drop-Down Form Field "on-the-fly" (and save them for future use), without having to open the Drop-Down Form Field properties window and manually adding the item
Scenario: We have a form created making use of Text Form Fields and Drop-Down Form Fields. Ideally, we captured all the information the end user might possibly require in the the Drop-Down Form Fields. Said end user is now using the completed form, and finds that there is an item missing from a Drop-Down Form Field that they want to add. Said end user does not have the rights/permission / knowledge to manually add items through the properties window. Is there a way to set up the Drop-Down Form Field so items can be typed into the form field while using the form (page is protected) and those items are appended to the existing list for the Drop-Down Form Field

Thanx in advance for any and all help.

 

[Charles Kenyon]

Hi,

1. Is there a way to "over-ride", "work-around", or "cheat" the 25 item

limit imposed on Drop-Down Form Fields" I need to have 8 selectable lists,
each from 0 through 120 that will be used to identify the length of certain
items. The 8 items are then SUMmed into a 9th Text Form Field. I am
currently using 8 Text Form Fields, but would rather use a Drop-Down Form
Field if possible.
No. The limit is real. You can use a UserForm with greater capacity but that
involves doing some programming. For more about online forms, follow the
links at <URL: http://addbalance.com/word/wordwebresources.htm#Forms> or

2. Is there a way to "append" or "add items to" a Drop-Down Form Field

"on-the-fly" (and save them for future use), without having to open the
Drop-Down Form Field properties window and manually adding the item?

Yes, using vba, but if you are going to do that, you might as well use a
UserForm. It won't be any more complicated. What you are talking about is
called a combo box.

See <URL: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm>.

Hope this helps,
--

Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

I have a few questions about the use of form fields that I can not seem to

find an aswer to anywhere else.

Scenario: We have a form created making use of Text Form Fields and

Drop-Down Form Fields. Ideally, we captured all the information the end
user might possibly require in the the Drop-Down Form Fields. Said end user
is now using the completed form, and finds that there is an item missing
from a Drop-Down Form Field that they want to add. Said end user does not
have the rights/permission / knowledge to manually add items through the
properties window. Is there a way to set up the Drop-Down Form Field so
items can be typed into the form field while using the form (page is
protected) and those items are appended to the existing list for the
Drop-Down Form Field?

 

[Jean-Guy Marcil]

Bonjour,

Dans son message, < Zokess > écrivait :
In this message, < Zokess > wrote:

|| I have a few questions about the use of form fields that I can not seem
to find an answer to
|| anywhere else.
|| 1. Is there a way to "over-ride", "work-around", or "cheat" the 25 item
limit imposed on
|| Drop-Down Form Fields" I need to have 8 selectable lists, each from 0
through 120 that will be
|| used to identify the length of certain items. The 8 items are then
SUMmed into a 9th Text Form
|| Field. I am currently using 8 Text Form Fields, but would rather use a
Drop-Down Form Field if
|| possible.

As Charles said, the limit is real, but there is a work around involving
programming:
See:

KB 198561

http://support.microsoft.com/default.aspx?scid=kb;en-us;198561&Product=ofw

||
|| 2. Is there a way to "append" or "add items to" a Drop-Down Form Field
"on-the-fly" (and save
|| them for future use), without having to open the Drop-Down Form Field
properties window and
|| manually adding the item?
|| Scenario: We have a form created making use of Text Form Fields and
Drop-Down Form Fields.
|| Ideally, we captured all the information the end user might possibly
require in the the
|| Drop-Down Form Fields. Said end user is now using the completed form,
and finds that there is
|| an item missing from a Drop-Down Form Field that they want to add. Said
end user does not have
|| the rights/permission / knowledge to manually add items through the
properties window. Is there
|| a way to set up the Drop-Down Form Field so items can be typed into the
form field while using
|| the form (page is protected) and those items are appended to the existing
list for the Drop-Down
|| Form Field?

If you insist on doing that with an formfields, you will need VBA.

Charles gave you a good place to start if you want to try userforms instead.
They are more powerful, easier to handle and make it easier to control user
interaction ...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Guest]

Charles,

Thanx I will take a look at that.

----- Charles Kenyon wrote: -----

Hi,

1. Is there a way to "over-ride", "work-around", or "cheat" the 25 item

limit imposed on Drop-Down Form Fields" I need to have 8 selectable lists,
each from 0 through 120 that will be used to identify the length of certain
items. The 8 items are then SUMmed into a 9th Text Form Field. I am
currently using 8 Text Form Fields, but would rather use a Drop-Down Form
Field if possible.
No. The limit is real. You can use a UserForm with greater capacity but that
involves doing some programming. For more about online forms, follow the
links at <URL: http://addbalance.com/word/wordwebresources.htm#Forms> or

2. Is there a way to "append" or "add items to" a Drop-Down Form Field

"on-the-fly" (and save them for future use), without having to open the
Drop-Down Form Field properties window and manually adding the item?

Yes, using vba, but if you are going to do that, you might as well use a
UserForm. It won't be any more complicated. What you are talking about is
called a combo box.

See <URL: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm>.

Hope this helps,
--

Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

I have a few questions about the use of form fields that I can not seem to

find an aswer to anywhere else.

Scenario: We have a form created making use of Text Form Fields and

Drop-Down Form Fields. Ideally, we captured all the information the end
user might possibly require in the the Drop-Down Form Fields. Said end user
is now using the completed form, and finds that there is an item missing
from a Drop-Down Form Field that they want to add. Said end user does not
have the rights/permission / knowledge to manually add items through the
properties window. Is there a way to set up the Drop-Down Form Field so
items can be typed into the form field while using the form (page is
protected) and those items are appended to the existing list for the
Drop-Down Form Field?

 

[Guest]

Thanx...I was hoping to be able to do this without getting into any programming...it doesn't look like I will be able to though. I will check your links though. Thanx again

----- Jean-Guy Marcil wrote: ----

Bonjour

Dans son message, < Zokess > écrivait
In this message, < Zokess > wrote

|| I have a few questions about the use of form fields that I can not see
to find an answer t
|| anywhere else
|| 1. Is there a way to "over-ride", "work-around", or "cheat" the 25 ite
limit imposed o
|| Drop-Down Form Fields" I need to have 8 selectable lists, each from
through 120 that will b
|| used to identify the length of certain items. The 8 items are the
SUMmed into a 9th Text For
|| Field. I am currently using 8 Text Form Fields, but would rather use
Drop-Down Form Field i
|| possible

As Charles said, the limit is real, but there is a work around involvin
programming
See

KB 19856

http://support.microsoft.com/default.aspx?scid=kb;en-us;198561&Product=of

|
|| 2. Is there a way to "append" or "add items to" a Drop-Down Form Fiel
"on-the-fly" (and sav
|| them for future use), without having to open the Drop-Down Form Fiel
properties window an
|| manually adding the item
|| Scenario: We have a form created making use of Text Form Fields an
Drop-Down Form Fields
|| Ideally, we captured all the information the end user might possibl
require in the th
|| Drop-Down Form Fields. Said end user is now using the completed form
and finds that there i
|| an item missing from a Drop-Down Form Field that they want to add. Sai
end user does not hav
|| the rights/permission / knowledge to manually add items through th
properties window. Is ther
|| a way to set up the Drop-Down Form Field so items can be typed into th
form field while usin
|| the form (page is protected) and those items are appended to the existin
list for the Drop-Dow
|| Form Field

If you insist on doing that with an formfields, you will need VBA

Charles gave you a good place to start if you want to try userforms instead
They are more powerful, easier to handle and make it easier to control use
interaction ..

-
Salut
______________________________________
Jean-Guy Marcil - Word MV
(e-mail address removed)
Word MVP site: http://www.word.mvps.or