how to check date ?

[Tu Quach]

Hi there, how are you?

I have question, assume I have a text box and gave it a format
date&time, how can I check when it is empty or not empty I use the code as

if frm_form!txt_name1 = Null then
msgbox "1"
else
msgbox "2"
end if

I only have a message 2 pop up, am I doing a wrong way? any help would
be great, thank you for your time
--------------------------------------------------------------------------

[Allen Browne]

Try:
If IsNull(txt_name1) Then

Nothing is ever equal to null. For an explanation, see:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tu Quach" <qu********@optusnet.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...

Hi there, how are you?

I have question, assume I have a text box and gave it a format
date&time, how can I check when it is empty or not empty I use the code as

if frm_form!txt_name1 = Null then
msgbox "1"
else
msgbox "2"
end if

I only have a message 2 pop up, am I doing a wrong way? any help would be great, thank you for your time

[xzzy]

just a guess, try testing for the value being a zero length string, which is
a different value than Null

if Len(txtBOX) = 0 or isnull(txtBOX) then
John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

Try:
If IsNull(txt_name1) Then

Nothing is ever equal to null. For an explanation, see:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tu Quach" <qu********@optusnet.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...

Hi there, how are you?

I have question, assume I have a text box and gave it a format
date&time, how can I check when it is empty or not empty I use the code as
if frm_form!txt_name1 = Null then
msgbox "1"
else
msgbox "2"
end if

I only have a message 2 pop up, am I doing a wrong way? any help

would

be great, thank you for your time