more not null Q???s

  • Thread starter Thread starter JOHN
  • Start date Start date
J

JOHN

there are many old record from the old excel spread sheet
that have many blank fiels. wont I loose records when a
require not null valuse in field in teh existing table?


-----Original Message-----
Why not set the fields required in the design of the table.
That should solve the problem.

Jim

.
Click to expand...
..
 
there are many old record from the old excel spread sheet
that have many blank fiels. wont I loose records when a
require not null valuse in field in teh existing table?
Click to expand...

Well, it won't LET you set the required property if the table has
nulls in any record in the field.

A Validation Rule won't work, because you want to allow existing
NULLs. You'll need to either update all the existing NULL fields to
some placeholder value ("Unknown" for text fields, some recognizably
invalid number for numeric fields); or else use the Form's
BeforeUpdate event to check whether the fields are null in newly
created or edited records.
 
Back
Top