IsNull not working

[vbjohn]

One of my fields is already pre-populated. And when you change any of the information on the textbox it gives an error:

Input Mask: 99/99;00;0;_

If IsNull(Me!txtRec_date) then
msgbox "You Must enter in a date", , gstrApplicationName
end if


For example:
it prepopulates the field as 02/21/2012
and i just only change one of them as... 02/22/2012 then it pops up.

Any ideas?

[RuralGuy]

Where do you have your code?

[vbjohn]

In the button clause. To make the change.

[RuralGuy]

You have it under a Command Button in the OnClick event?

[vbjohn]

In the Click event, yes.

[RuralGuy]

Try putting it in the AfterUpdate event of the YourDate control.

[vbjohn]

It still brings up: "The value you entered isn't appropriate for the input mask '99/99;00;0;_' specified for this field.

I put in a breakpoint on the first line and it does not hit it.

[RuralGuy]

Before you show the error, put in a MsgBox that displays the field so you can see it.

[vbjohn]

It does not even hit that sub-routine when i click on it. The first line of the code I put a breakpoint in.

[RuralGuy]

You *must* make a change to the date to get an AfterUpdate event.

[vbjohn]

and I have done that.

[RuralGuy]

You do not get a MsgBox with the contents of the field when you make a change to the control?

[vbjohn]

That is correct. I get nothing coming up.

[RuralGuy]

Care to zip up your db and post it? Remove any sensitive data of course.

[vbjohn]

It is a big file and with a lot of sensitive information on it. I will see what I can do.