Make sure you have allow nulls set to True in your table design.
Also, make sure the default value is null and not zero.
When describing errors, it helps to tell us the text of the error message.
Dorian
"CD Tom" wrote:
> I don't understand why but I'm sure having problems with an insert statement.
> The problem I'm running into is when I try and insert a number field with
> nothing in it. The field could sometime have a number and other times be
> blank. If I leave the field as null I get and insert statement error. I
> test the field for null and make it blank " " and I get the same error. Why
> is it so difficult to leave a number field blank. Hopefully someone can give
> me an answer. Thanks for any help.
>
>
|
Similar Threads
