Forum Discussion
Data Validation List - How to disable autocomplete
I have some drop down lists using Data Validation that are for the convenience of my users. I do not want to restrict data to the list, so I've turned off error messages. However, with the new AutoComplete feature, it messes up entry of certain things. For example, I have 5 1/2 and 6 1/2 in the list among other numbers. I want to be able to enter any number still, but when I enter 2 for example, it narrows the list to 5 1/2 and 6 1/2 and selects the highlighted one from the list when I hit enter. The work around is to type 2.0 but I don't want my users to have to do this. How do I turn AutoComplete off. It is a great feature for most situations, but it is a pain for the application I'm using. Thank you for your help.
2 Replies
- I am afraid you can not disable it.
Maybe you need create a dropdown by yourself.- Thank you. Unfortunately, I have a significant number of files and locations that I have used the data validation drop down that is used in tools by many users. This is a fairly significant undertaking. I do not understand why Microsoft adds a new "feature" without thinking through the ramifications to existing applications. I appreciate you providing the answer, even if I don't like it. Thank you
