B BunBun Feb 18, 2004 #1 i m looking for criteria expression for a blank field i try many variations,eg =" ", "null" can anyone help? thx
i m looking for criteria expression for a blank field i try many variations,eg =" ", "null" can anyone help? thx
J Jeff Boyce Feb 18, 2004 #2 If Nz([YourField],"") = "" Then ... NOTE: there is NO space between the double quotes in the above expression. A zero-length string ("") is NOT the same as a space (" "), nor the same as a Null.
If Nz([YourField],"") = "" Then ... NOTE: there is NO space between the double quotes in the above expression. A zero-length string ("") is NOT the same as a space (" "), nor the same as a Null.
