Hi,
Probably you field has property, which prevent emty
values. So it does not allow to store empty values into
it. NULL is special case, it is not empty value. What you
can do is to check if your value is empty. If it is, then
assign NULL to field.
Val
Quote:
>-----Original Message-----
>Hi all,
>I have connected my app to an Access database. When
modifying the records or
Quote:
>adding a new one, I can't have a blank field: I get
an "invalid utilisation
Quote:
>of null" error. Though, If I leave the field without
touching it (it is
>blank then...), I do not have the error!! It's a problem
because if the user
>started to fill the field and decides in the end to leave
it blank, I will
>have an error preventing the app to modify the .mdb!
>Any ideas guys ?
>.
ADO Error