Textbox null value not being recognised 1

[Frank72]

Hows it going?

i have a text box with a date format. in a code module i have "if txtdateupto = null then" when i debug and the text box is left empty the if is passed over even though the pop up value indicator shows that it is null. has it something to do with the date format?

thanks alot

frank

 

[JimHorton]

Use the IsNull(), ie
IF Isnull(me.txtdateupto) then...
--Jim