table entries

[Guest]

When creating a table that has a column which uses a yes/no data type, is
there a way to secure the column so that I don't accidentally click on a
field and change the "yes" to a "no" or vice versa. I have had a few
occurences of doing this, but luckily my database isn't large enough (at the
moment) that these mistakes haven't gone unnoticed. Thanks.

 

[Rick B]

If you are entering data through a form you could disable that field, move
it to the bottom of your form, not include it as a tab stop, move it to a
separate tab, pop up a confirmation box if changed, etc.

All kinds of options. The key though is that you must be working in a form.
Once you build a table's structure you should not be working in that table.
All data entry should be done through forms (or maybe a query). Tables are
pretty much buckets to store your data; they are not designed to be used as
your user interface.

Hope that helps.