Check the content for a bound textbox

[Mihail]

Hello !
Can you help me, please !

I have a bound textbox (to a field in a table).
I wish to check if this textbox become empty while I type into.

I have tried:

    If txtValContor = "" Then...
    If IsEmpty(txtValContor) Then...
    If IsNull(txtValContor) Then...
 

but with no success.

Seems that all this checks the value in the bound field, not what I see in my [Z{snip}] textbox.

Thank you !

[Mihail]

Oups. Solved (after 2 hours. UFF).
If txtValContor.Text = "" Then...

[zmbd]

Where exactly are you entering your code?

[Mihail]

OK with the profanity, zmbd, (but I have white hair after 2 hours for a "simple" task).

This is my code:

Private Sub txtValContor_Change()
    Dim Vis As Boolean
    Vis = (txtValContor.Text <> "") And (Not IsNull(txtValRepartitor))
    cmdOpenFormCitireRepartitoare.Visible = Vis
    cmdOpenFormCitireCI.Visible = Vis
End Sub
 
Private Sub txtValRepartitor_Change()
Dim Vis As Boolean
    Vis = (Not IsNull(txtValContor)) And (txtValRepartitor.Text <> "")
    cmdOpenFormCitireRepartitoare.Visible = Vis
    cmdOpenFormCitireCI.Visible = Vis
End Sub
 

I have to check two bound textboxes in order to show/hide two command buttons.

Every time I have needed to check the "other" textbox for NULL because the TextBox.Text works only if the control (the textbox) has the focus.

Hope that this is the answer you espect.

[zmbd]

ahh.. it is the simple tasks that age us - hence children.
My work has a very strict profanity filter. In this case, your thread would have been blocked until I got home - worse, a copy of the page would have been sent to my IT security team who would more than likely decided that the entire site needed to be blocked as they error on the side of scorched-and-salted earth.

Yes, the dot-Text requires the control to have the focus; however, you can usually use the dot-Value - just depends on the information you need returned from the control.