Button Hidden When Field Is Null

[rad1182]

Hello Everyone,

I have a form that has a field called LastName and a button called CmdEdu, which opens ups another form.

I want the CmdEdu button to be hidden whenever the LastName field is null.

I've tried a code in Form_Current() and it works in hiding the button when the field is null, however whenever I type something into the LastName field and then tab over to the next field, the button doesn't appear.

The code is:



If Nz(Me!LastName, "") = "" Then
Me!CmdEdu.visible = False
Else
Me!CmdEdu.visible = True
End If

Thanks in advance.

[orange]

Try this: the Cuirrent event is the right spot.

If IsNull(Me!LastName) OR _
Len(Me!LastName & "") = 0 Then
Me!CmdEdu.visible = False
Else
Me!CmdEdu.visible = True
End If

Should pick up Null and zero length string, I think

[rad1182]

Hey orange, thanks for the suggestion, but the same thing happens. The code does hide the button, but when I fill in the LastName field and then tab over to the next field, the buttons are still hidden. If I save the record, scroll to a previous record, then go back to this one then the button does appear. However, I want the button appear as soon as I tab over from the LastName field. Any suggestions on how to do this would be greatly appreciated.

Thanks again.

[orange]

Try putting the same code in the AfterUpdate event of the LastName control.
What exactly are you doing when you say "then tab over to the next field"?
Are you entering a lastname value then moving to the next control?

You may have to do a Me.Requery.... hmmm not sure. Try without, or try with in the AfterUpdate of the Lastname control

[rad1182]

Yes, moving on to the next control...that's what I meant.

Putting the same code in the AfterUpdate event of the LastName field works. Thanks for the help!

[orange]

Glad to help.