Null Values

[paulS30berks]

wondered if someone could help.

I have just appended 100 or so records into a table.

Once appended 2 of these records within the table have included the word "Null" into fields not occupied by any content.

I have tried deleted the word null from the table and an error appears:

"You tried to assign the Null value to a variable that is not a variant data type"

If I can help it I dont want to delete records from table and reappend.

Thanks

Paul