Insert statement error

[Guest]

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.

 

[Guest]

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