Make Button Disappear under conditions

[magmike]

I having a problem with an If Then Statement:

I have a button (SeeAllContacts) on the Tab (Contacts) that I am
trying to either hide or Disable when the IDNo. field is empty. I am
using the On Current function for the form, but it is not working.

Here's the code:

If IDNo = "" Then
Me.SeeAllContacts.Enabled = False
End If

Thanks in advance!

 

[akphidelt]

Try doing this... and im not sure if it works on the on current function. I
usually use
after update or on load

If IsNull(Me.IDNo) Or Me.IDNo = "" Then
Me.SeeAllContacts.Visible = False
Else
Me.SeeAllContacts.Visible = True
End If

 

[Tom Wickerath]

Alternatively, you can try something like this:

If Len(Me.IDNo & "") = 0 Then
Me.SeeAllContacts.Visible = False
Else
Me.SeeAllContacts.Visible = True
End If


This concatenates a zero length string (ZLS) to the IDNo. Therefore, the
result can never be null, but it can still be zero length.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[akphidelt]

Gotta watch out for them MVPs... tricky tricky!! : )

 

[Tom Wickerath]

Glad to pass along a new trick that you can add to your bag of tricks! <smile>


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[liuwei]

???