Blank Records in Table

[anwaar]

Guys,



Can anyone help me out that how I can autometically remove blank records from access table??

[pbaldy]

You can't automatically remove them (via some setting anyway). They should probably be prevented in the first place, via required fields, etc. To delete them you can use a query:

DELETE *
FROM TableName
WHERE KeyFieldName Is Null

[anwaar]

Thanks Paul,

Problem solved.

[pbaldy]

Happy to help.