If Then Else the moment a txtbox is entered

[kupe]

In If...Then...Else on a textbox, can I state something like "if anything at all is entered here", please? Or can I say apply this ForeColor upon enter with IF...Then...Else?

I thought an If Then Else because I want the normal controls to apply for the following record(s).

 

[Mile-O]

If anything is entered in a textbox then you can use the IsNull() function. If it's True then the textbox is empty; if it's false then the textbox has something entered into it.

ie..

If IsNull(Me.MyTextBox) = True Then
    MsgBox "Empty"
Else
    MsgBox "Has Text"
End If

 

[kupe]

I was thinking of returning to 'normal' with Lost Focus, but yours has to be the way. Many thanks, MoP. Cheers