How do I un-restrict my drop down list field on a template?
 

Hi there - I've got a field/column set up as validated data with a large
amount of options to choose from in a drop-down list. Here are the issues my
users are having:

1) they have to actually select the choice before they can access it in
future records
2) they want the ability to type in whatever they want (w/o having to choose
from the list) ... is there a way to give them that option?

please advise!
Thanks!
~k.

How do I un-restrict my drop down list field on a template?
 

Turn off Error Alert if the DV is a List


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 13:26:02 -0700, Kara7
wrote:

Hi there - I've got a field/column set up as validated data with a large
amount of options to choose from in a drop-down list. Here are the issues my
users are having:

1) they have to actually select the choice before they can access it in
future records
2) they want the ability to type in whatever they want (w/o having to choose
from the list) ... is there a way to give them that option?

please advise!
Thanks!
~k.