SQL NULL

[DS]

I have a Date field. If its blank and I have the syntax # " &
Forms!frmOne!TxtDate & " #
I get an ERROR

But

If I do This ""# " & Forms!frmOne!TxtDate & " #""
it works.

My question is. Is it really working or is this going to come back and bite
me later? Or should I use...

If(IsNull(Forms!frmOne!TxtDate),"",Forms!frmOne!TxtDate)

Thanks
DS

 

[DS]

Sorry Allen,
I'm using as a part of an Insert statement in SQL.
Thanks
DS

 

[Allen Browne]

I'm still not clear if you are in SQL View (in the query designer), or
writing a SQL string to execute (in the VBA code window.)

Either way the article I linked will address the issue for you.

The link again was:
http://allenbrowne.com/ser-36.html