why this message dispaly "you tried to assign null value to a variable that is n

[sharmamk1966]

I create ms access database. In field level i get problem in date/time field
when i enter any date manually it accepted, if i delete it display this
message "you tried to assign null value to a variable that is not a variant
data type" why?

 

[Jerry Whittle]

I'm assuming that you are entering these dates in a form and not driectly
into the table. Therefore there's probably some code behind the form for that
field. Open the form in design more and look at the Event properties for that
field. Is there any code listed? If not check the properties for the entire
form.

 

[John W. Vinson]

I create ms access database. In field level i get problem in date/time field
when i enter any date manually it accepted, if i delete it display this
message "you tried to assign null value to a variable that is not a variant
data type" why?

What's the context? That error message appears to be one that you would get in
a VBA code module, not in a table. How are you doing the delete? What's the
context?

 

[David W. Fenton]

I create ms access database. In field level i get problem in
date/time field when i enter any date manually it accepted, if i
delete it display this message "you tried to assign null value to
a variable that is not a variant data type" why?

Funny you should post on this. I'm working on an app I just took
over for a client, and it was developed a long time ago (mid-90s,
Access 2). One subform has a join between two tables and when I
delete the value in the child table that joins that record to the
parent, I get exactly that error.

Is the field you're getting the error with possibly being used in a
JOIN?

 

[sharmamk1966 via AccessMonster.com]

thanks for reply.
I resolve this problem at the same day after e-mail on monster. you are right
to say that
check the properies. I set the table properties and get every thing is ok.
but one query is there arise when we transfer data in date field the date
store in "MM/ddyyyy" formate where as i use and set regional date in
"dd/MM/yyyy" format. why this Happen.
regard.