Home > IT Answers > Database > Access
gooman
5 pts.
 Access
Microsoft Access 2010, Microsoft Access tables
How do I change the selected columns to be required pieces of information?

Software/Hardware used:
ASKED: October 10, 2012  4:30 PM
UPDATED: October 10, 2012  4:59 PM
Answer Wiki:

Open table in Design View, select the column, and change two properties:

Change Required to Yes.

Change Allow Zero Length to No.

This won't work with AutoNumber data type, but for all others it will.

Last Wiki Answer Submitted:  October 13, 2012  11:59 pm  by  RaBinNOLA   60 pts.
All Answer Wiki Contributors:  RaBinNOLA   60 pts. , Michael Tidmarsh   11,390 pts. , gooman   5 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

It sounds like you are wanting to set up the database such that people can input data.  If so, they should not really be inputting directly into a table.  There should be an input form that checks the data before adding it to the data table.  That form could also enforce any required fields.

tlsanders1
 1,240 pts.