Make field required

  • Thread starter Thread starter Dan @BCBS
  • Start date Start date
D

Dan @BCBS

I have a table with 50k records. I need to change one of the fields to
required and default to "No" (the field is a text field). There are many
records which have Null in this field. So, I have tried to add "No" to the
ones that are Null by using Replace (shift+F). Once it finally stops looking
a window tells me that it finished looking and the item was not found. But
there are thousands that are Null.
How else can I make these field "No" so that I can get on with making it
required and default to "No"???
 
Just create an update query that updates the field to "No" where the field
value is Null.

Make a backup copy of your mdb.
Create a new query.
Select the table.
Select the field you want to update
Change the query type to Update
Put No in the Update To row
Put Is Null in the Criteria row.
Run the query.

Now just open your table in design view and make the Default Value No.
 
Back
Top