What is the result of {DELETE}

craigachan

Registered User.
Local time
Today, 07:31
Joined
Nov 9, 2007
Messages
285
If I have a string in a field, select the whole field, then press the delete key, what is the value of the field? "", Null, or ?
 
If the field is set to "" after I press key 'Delete', then I should be able to:

If myfield = "" Then
msgbox "Field is empty"
End If

However, the field is not "". It just passes over this code. I've tried the same with IsNull(myfield) and myfield is not null.

Any thoughts?
 
I usually use:
If Len([MyField] & "") = 0 Then
...to cover most situations including Null.
 
I usually use

If Len(Nz(MyField, "")) = 0 Then
 

Users who are viewing this thread

Back
Top Bottom