C craigachan Registered User. Local time Today, 07:31 Joined Nov 9, 2007 Messages 285 Sep 6, 2010 #1 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 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 ?
RuralGuy AWF VIP Local time Today, 08:31 Joined Jul 2, 2005 Messages 13,825 Sep 6, 2010 #2 It is set back to "".
C craigachan Registered User. Local time Today, 07:31 Joined Nov 9, 2007 Messages 285 Sep 7, 2010 #3 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?
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?
RuralGuy AWF VIP Local time Today, 08:31 Joined Jul 2, 2005 Messages 13,825 Sep 7, 2010 #4 I usually use: If Len([MyField] & "") = 0 Then ...to cover most situations including Null.
C craigachan Registered User. Local time Today, 07:31 Joined Nov 9, 2007 Messages 285 Sep 7, 2010 #5 Thanks, I'll give it a try. Great Idea.
D dbDamo Registered User. Local time Today, 15:31 Joined May 15, 2009 Messages 395 Sep 7, 2010 #6 I usually use If Len(Nz(MyField, "")) = 0 Then
C craigachan Registered User. Local time Today, 07:31 Joined Nov 9, 2007 Messages 285 Sep 7, 2010 #7 Thanks for the great advice.