M
Mike Farmer
I still cannot locate where the "bad" data is coming from. Is there some
"code" I can use to direct me to the specific field that is causing the
problem?
Regards,
Mike
-------------------------------------------------------------------------
Mike
Most likely it is not one of the fields you have data in. It is probably
one of the other fields. Check the "Required", "Allow zero length", and
"Indexed" properties of the other fields. If "Required" is yes it means you
can't have a blank in that field. Also true if "Allow zero length" is no.
If "Indexed" is yes (no duplicates) you can't have 2 records with the same
data. A blank would count as data so you can't have 2 records with a blank
in that field.
Kelvin
"code" I can use to direct me to the specific field that is causing the
problem?
Regards,
Mike
-------------------------------------------------------------------------
Mike
Most likely it is not one of the fields you have data in. It is probably
one of the other fields. Check the "Required", "Allow zero length", and
"Indexed" properties of the other fields. If "Required" is yes it means you
can't have a blank in that field. Also true if "Allow zero length" is no.
If "Indexed" is yes (no duplicates) you can't have 2 records with the same
data. A blank would count as data so you can't have 2 records with a blank
in that field.
Kelvin