Insert null value in column-type is date/time & format is ShortDate ,in Access 2002

[billa856]

Hi,
I am trying to insert Null value in column(ShipDate ) in my table.That column(ShipDate )'s type id date/time and format is short date.

I am using "" to insert Null in that column(ShipDate ) but it shows warning that
customer can't append all the records in the append query.
Customer set 1 field(s) to Null due to a type conersion failure,and it didn't add 0 record(s) to the table due to key violation, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.
Do you want to run the action query anyway?

But still if I click on Yes than it will simply execute the query and insert null value in table.
And if I click on No than it cancel the execution of query.

its caused just because i set type as date/time and put format as short date in that column(ShipDate ) in my table.

How can I remove this warning?

[NeoPa]

Your first order of business is to clear the problem. Only then do you want to think about removing warning messages.

Start with understanding the difference between Null and an empty string ("" or '') as you've actually tried to use. When you have this sorted, go to the design of the field and make sure that the Null (or empty string if that's what you plan to use) is accepteed as data for that field.

When that's all sorted let us know how you got on and if there's anything further you need.