A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Drop down field options in forms



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2010, 02:22 PM posted to microsoft.public.word.docmanagement
Is
external usenet poster
 
Posts: 1
Default Drop down field options in forms

Can I have a blank free text option as one of the options in my drop down
list in a form? I want my form to have a list to choose from but if
necessary the form can be completed by the editors own choice not listed.
Word 2003 and 2007.
  #2  
Old May 24th, 2010, 02:43 PM posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Drop down field options in forms

No, a dropdown form field can include a blank option (create it with a
space) but not a fillin one. For that you need a combo box, which is an
ActiveX component (not compatible with a protected form).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Is" wrote in message
...
Can I have a blank free text option as one of the options in my drop down
list in a form? I want my form to have a list to choose from but if
necessary the form can be completed by the editors own choice not listed.
Word 2003 and 2007.


  #3  
Old May 24th, 2010, 02:57 PM posted to microsoft.public.word.docmanagement
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Drop down field options in forms

No, but you could have an option such as 'Enter your own value" then you
could use a macro to detect that choice and offer an input box for the user
to enter a choice which would then replace that choice. Assuming the
dropdown field Dropdown1, put an item at the end of the dropdown list "Enter
your own value" then run the following macro on exit from that field

Sub ExitDD1()
Dim sChoice As String
Dim fDD As FormFields
Set fDD = ActiveDocument.FormFields
If InStr(1, fDD("Dropdown1").Result, "Enter your own value") Then
sChoice = InputBox("Enter your own")
With fDD("Dropdown1").DropDown.ListEntries
.Item("Enter your own value").Delete
.Add sChoice
fDD("Dropdown1").Result = sChoice
End With
End If
End Sub

This replaces the "Enter your own value" item with the input value and sets
that as the result.
http://www.gmayor.com/installing_macro.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Is" wrote in message
...

Can I have a blank free text option as one of the options in my drop down
list in a form? I want my form to have a list to choose from but if
necessary the form can be completed by the editors own choice not listed.
Word 2003 and 2007.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.