Validation error in append query (1 Viewer)

[JerryDi]

When appending data from a table to an identical table I get a validation error on some but not all records. Any suggestions ?
Jerry

 

[Pat Hartman]

Check the field properties of the fields in the new table. Your problem is probably caused by the "Allow zero length" property being defaulted to No for some of the text fields.

 

[JerryDi]

Many thanks, it works perfectly now...
Jerry