can't insert a record into the table

[Dou]

Have a digital field and two date field in the table.
I want to insert a record into the table using the statement
INSERT INTO, If I only input other data, let the digital field's
textbox and date field's textbox empty,then I can't insert a record
into the table. I have set digital and date field's Required property
to No. How to solve this problem? thanks.

 

[JohnFol]

It's not clear if there are other fields in the table, or what the error is.


What if you open table using the UI and enter a new record leaving the
digital (Numeric) and date fields empty?

 

[Dou]

Yes, there are other fields in the table.
if I open table using the UI and enter a new record leaving the
digital (Numeric) and date fields empty, It's ok.
But It can't insert a record into the table using INSERT INTO statement when
input data in the form and leaving the digital (Numeric) and date fields
empty.

 

[RC West]

You might want to set the property "Allow Zero Length" for any text fields
in your table to allow zero length(Yes) strings.