Set (9) fields to Null due to type conversion failure !!!!

[Pietro]

Hi,
I'm trying to append query1 to table2,one of query1 's field is an
external one called "Language",the query gets this field from [forms]![update
cap]![language],when i run the append query,with the form "update cap" open
and the field "Language" is not null,i get an error message "Customer Support
cannot update all records in the append query,Customer Support set (9) fields
to Null due to type conversion failure,(0) records due to ....etc."
Although ,when i check the append query in datasheet view,i can see the
language field that already got the data from [forms]![update cap]![language].
The field "language" of table1 is set to text (255)
Can anybody help?

 

[Arvin Meyer [MVP]]

Type conversion failure is a data type. Apparently you have a mismatch in
those fields.

 

[Clif McIrvin]

Type conversion failure is a data type. Apparently you have a mismatch
in those fields.

Also, the error message doesn't tell you which field (or fields) had the
type conversion error -- it may not be the language field at all.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi,
I'm trying to append query1 to table2,one of query1 's field is an
external one called "Language",the query gets this field from
[forms]![update
cap]![language],when i run the append query,with the form "update
cap" open
and the field "Language" is not null,i get an error message "Customer
Support
cannot update all records in the append query,Customer Support set
(9) fields
to Null due to type conversion failure,(0) records due to ....etc."
Although ,when i check the append query in datasheet view,i can see
the
language field that already got the data from [forms]![update
cap]![language].
The field "language" of table1 is set to text (255)
Can anybody help?