The 'Required' flag is equivalent to declaring a Column as NOT NULL using the Data Definition Language of SQL. That is NULL values will not be accepted.
As far as I know you can't change a NULLable column to NOT NULL once it has been defined without dropping the table and recreating it. This is because any existing data in the table may break this constraint.
When you change a column to Required in the Access table design mode it warns that it will verify the existing data and actually drops the table and recreates it if necessary.
So that's the solution for you as well. You'll need to check for null values in the column and replace them with something else such as an empty string or a zero, drop the table and finally recreate the table with the column redefined. Don't forget to reinstate all the indexes and foreign keys etc for the table as well.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.