Looking for relevant Microsoft Windows Whitepapers? Visit the SearchWinIT.com Research Library.
Euhodos | May 17 2008 5:31PM GMT
Is the question - Can I have a list validation rule but still allow free text entries, say as an exception or in lieu of an “Other” list item?
If so, simply do not turn on the Error Alert (3rd tab of Data Validation). That way the user can still benefit from the drop-down list, but have flexibility to handle exception.
I don’t believe this is a good database management technique, but I’ve used it myself many times.