How do you alphabetize an InfoPath list?

How do you alphabetize an InfoPath list? I'm connecting to a SharePoint list in InfoPath via a drop-down list box and would like the list to be alphabetized, reqardless of the order of the list in SharePoint.

Better yet may be to be able to create/ use some sort of auto-complete funtionality where as you type a name those that do not match are filtered out.

Best would be a combination of both.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Clay FoxDirector of Business IntegrationCommented:
InfoPath takes whatever the default list view is.  The only thing I have doen is setup the default view the way I want it in InfoPath and have everyone else use another view.  The other option is heavy coding which I would not recommend.

You can setup a field that you can use as a conditional formating for the repeating table, etc. However you cannot get the dynamic type through you are looking for.  The best you can do is enter a text string and then tab out or press a button to have the list refresh and filter accordingly.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JaemoeAuthor Commented:
Well, it's not the answer I was hoping for but if that's the case then I guess I'll just have to communicate this to the party responsible for maintaining the SharePoint list.

I am going to wait a bit to see if any other experts chime in. If all reponses are the same then points will be awarded accordingly.

Thank you clayfox for the quick response.
JaemoeAuthor Commented:
Unfortunately I have not found this to be untrue. Thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.