Is null or empty field

[dr223]

Hallo,

I have this code of line which works fine if the field is populated with NULL but doesn't work if it is an empty field, please can someone tell me how I can modify it so that it can recognise an empty field too, Thanks

isnull ({QryQuarter2.address1})

 

[wazz]

or ({QryQuarter2.address1}) = ""

 

[boblarson]

Or simply:

If Len( (QryQuarter2.address1} & "") = 0 Then


That will handle nulls AND empties.

 

[wazz]

i usually use

If address1 & "" <> "" Then