Object required error 1

[dkwong]

I can't figure out why there's this error in my VBA code:

If Me.AccMgr_Client_Code Is Null Then
[b.Client_Code].Value = [Client_Code]
End If

This gives an "object required run time error '424'" on the first line. I want to check if a textbox is null and if it is to assign a value to it. Thanks!

 

[dds82]

Textbox controls are never null. What you really want to do is check if its text is empty.

 

[KyleS]

I'm pretty sure the "IsNull" should look like this:

If IsNull(Me!AccMgr_Client_Code) Then
[b.Client_Code].Value = [Client_Code]
End If

But in some cases you'll have a zero-length string "" which this won't catch. The way to get both at the same time is to use something like this:

If Len(Me!AccMgr_Client_Code & "&quot = 0 Then
[b.Client_Code].Value = [Client_Code]
End If

Kyle