Thanks again Allen.
No did not blank it with zero string.
But I realized my mistake. I was typing [VisitDate] ...where the data will be
stored instead of typing the name of the text box which was Text68. Once I
corrected the mistake it is working well.

Once again
Thanking you
HNIM2010

Allen Browne wrote:
Did you blank the text box by setting its value to a zero-length string?
That's not a valid date. Set it to Null instead.

Hi Allen,
Thanks for your response.
[quoted text clipped - 28 lines]
Thanking you in advance
Leo

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1