Hi,
Use Null.
rst.Fields("FieldName") = Null
That assumes the field CAN accept null (some fields, like the primary
key, cannot).
Nothing is to be use for objects only, not for values.
A string with no character, "", is still a string, like zero is still a
number.
NULL is a kind of metadata telling that there is no data available.
Empty, as IsEmpty, is use to see if a variable has been already assigned
(it is quite rare you fall on such beast).
Missing, as IsMissing, is use to see if an optional argument, without
default value, has been supplied.
So, only Null, can do the job, here, to specify that the value of the
field is to be considered absent.
Hoping it may help,
Vanderghast, Access MVP
