stupid question here: Limit what can be entered into column

[travismp]

I have a simple "Value List" with about 5 choices. I only want my user to be able to select one of those 5 options, I do not want them to be able to add any other value into that column. What option do I select to lock the column down to only allow what is on that list?

Second question. The table already has thousands of records, I know there will be some that have data that is not in the list of 5. What will happen to those if I lock it down now?

thanks.

 

[pbaldy]

Set Limit to List to yes. That setting should have no effect on existing records.

 

[travismp]

thank you pual. I could find it in the forms, but was hoping to set it on the table. THANK YOU SIR.

 

[boblarson]

If you have lookups defined at table level I think you need to read this:

http://www.mvps.org/access/lookupfields.htm

 

[neileg]

thank you pual. I could find it in the forms, but was hoping to set it on the table. THANK YOU SIR.

You should not let the users loose at table level. I prefer to have a minimum of formatting/validation etc at table level and apply this in the forms.