more not null Q???s

[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

.

..

 

[John Vinson]

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?

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.