Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / February 2006

Tip: Looking for answers? Try searching our database.

Drop-down text box data not editable when filling out form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kent - 13 Feb 2006 20:39 GMT
Hi all,

I was previously designing dynamic forms on an Excel platform using VBA
code.  In VBA, there is, of course, a Drop-Down List Box object, very similar
to the one found in InfoPath.  There is a big difference between the two
though that really is a drag.  On the VBA Drop-Down List Box, one has the
ability to select an item from the list box, and/or add text to the box
manually.  There does not seem to be such a capability with InfoPath; it
appears that you simply get to pick an item from a static list, and cannot
modify it, add to it, or change it in any way.

Am I missing something, or am I stuck?  It's pretty darn handy to have it
work the way it does with VBA code....actually, it's more than handy...it's
necessary in most of our cases.

What about addition property feature that could allow a user to modify the
text entry that's been selected or not?

Feedback is greatly appreciated.

Thanks in advance,

Kent
Kalyan Reddy - 13 Feb 2006 23:03 GMT
Hi Kent,
The feature you are looking in drop down boxes can be achieved using Smart
Combo box
Take a look at this link below
http://www.infopathdev.com/webstore/detail.aspx?itemid=14
Hope this will help you
Signature

Kalyan Reddy
Visit http://www.autonomysystems.com

> Hi all,
>
[quoted text clipped - 28 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=af3a1512-fb42-4
ab9-a781-972c7bd2edbc&dg=microsoft.public.infopath
Adam Harding - 14 Feb 2006 10:16 GMT
Kent

I get around it by havning an other option in my drop down box that reveals
a text box if selected.  Works fine and very intuitive.

> Hi all,
>
[quoted text clipped - 28 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=af3a1512-fb42-4
ab9-a781-972c7bd2edbc&dg=microsoft.public.infopath
JDArsenault - 14 Feb 2006 16:03 GMT
Kent & Adam,

I'm having the same issue due to organizational changes. A cascading drop
down was fine until parallel systems were put into effect.

Adam,

Can you elaborate on your method? Are you talking about creating a rule on
your drop-down or different form views? I'm very intereseted to here how you
go about this. As I mentioned, I have cascading drop-downs so where I
override one field, I would have to do the same in another.

Thanks for your help.

> Kent
>
[quoted text clipped - 33 lines]
> >
> > http://www.microsoft.com/office/community/en-us/default.mspx?mid=af3a1512-fb42-4
ab9-a781-972c7bd2edbc&dg=microsoft.public.infopath
Adam Harding - 16 Feb 2006 11:10 GMT
JDArsenault

Quite straightforward utilising Conditional Formatting to reveal the text
box when the dropdown list equals a specific value eg Other so my conditional
format on the text box reads

If DDlist is not equal to Other then hide this control

Job done

You can make the DDList disappear also by using conditional formatting to
say if text box is not blank then hid control.  You could replace ALL your
DDLists with text boxes on this one occurence to provide the functionality
you seek.

I hope this makes sense

Cheers Adam

> Kent & Adam,
>
[quoted text clipped - 47 lines]
> > >
> > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=af3a1512-fb42-4
ab9-a781-972c7bd2edbc&dg=microsoft.public.infopath
JDArsenault - 16 Feb 2006 17:35 GMT
It sorta makes sense, and I'm sure it'll make more sense once I try it. I'll
let you know how it works out.

Thanks Man!

> JDArsenault
>
[quoted text clipped - 66 lines]
> > > >
> > > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=af3a1512-fb42-4
ab9-a781-972c7bd2edbc&dg=microsoft.public.infopath
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.