VBA Access Textbox returning Null Value

Question

I have a VBA Access userform. In this useform there is a textbox with the name txtSearch_POBOX. I'm trying to get its value using the code below:

Private Sub txtSearch_FirstName_Change()
MsgBox ([Form_Client List].txtSearch_POBOX.Value)
End Sub

But this is constantly returning NULL. When even when there is a value inside the text box. Any ideas?

Gustav · Accepted Answer · 2015-03-08 08:08:54Z

1

Your reference is wrong. It should read:

MsgBox Forms![Client List]!txtSearch_POBOX.Value

As it could be empty, you should use:

MsgBox Nz(Forms![Client List]!txtSearch_POBOX.Value)

answered Mar 8, 2015 at 8:08

Gustav

56.4k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wiz · Accepted Answer · 2015-03-09 14:25:50Z

remember that if you want to intercept the text box value while digiting, until you "validate" the content change (e.g. losing focus) the .Value property is not updated.

For instance I used a text box to make a running filter of a submask: I wanted to filter the submask while digiting. To do this you need to use the .Text property.

In the following example I make a running filter of a list of Publishers:

Private Sub txtNameFilter_Change()
On Error Resume Next
    Dim strFilter As String

    If Not IsNull(Me.txtNameFilter.Text) Then
        strFilter = "Publisher LIKE '*" + Me.txtNameFilter.Text + "*'"
        Me.Filter = strFilter
        Me.FilterOn = True
        Me.txtNameFilter.SelStart = Len(Me.txtNameFilter.Text)
    End If
End Sub

Bye Wiz

Collectives™ on Stack Overflow

VBA Access Textbox returning Null Value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related