urgent: criteria expression for a blank field?

B

BunBun

i m looking for criteria expression for a blank field
i try many variations,eg =" ", "null"

can anyone help?

thx
 
J

Jeff Boyce

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.
 
Top