How to check for empty string?

[robin27th]

Hi,
I am very new to access. I am asking something basic.

Private Sub Command12_Click()
    Dim strAbc As String
    strAbc = "a"
    MsgBox IsNull(strAbc)
    MsgBox IsEmpty(strAbc)
End Sub

How to check if variable strAbc has a value/is not an empty string? I tried isNull and isEmpty and both returns false whether strAbc is assigned "" or "a".

Thanks,
Robin

[MikeTheBike]

Hi

You could try this

MsgBox strAbc <> ""

??

MTB

[munkee]

I use the following to check for null and zero length string of a control. Just replace control for your string variable.

Len(Nz(Me.controlname, "")) = 0

or you can just use the straight

len(string) < 1

[NeoPa]

Robin, It's important to know what you are dealing with when making such a check. As yours clearly states it is a string variable, then the correct way to check it would be as Mike has suggested - (strABC = "").

On the other hand, form controls are objects that may contain Null. Checking form controls should be done using IsNull() instead - (IsNull(Me.txtA BC)). Controls with no data entered are never empty strings. Nz() may be used for simplifying usage of the control's value, but is not a good way to test if anything has been entered.