Inactive button till field is filled 1

[Zeroanarchy]

I know this is pretty simple but some times u find easy things hard and hard things easy.Some times u just start to think complex.

All I am trying to do is make a button inactive until a value has been placed in a field. Thanks to anyone in advance for your help on this one.

 

[Kalin]

Set the Locked property from the button to True

Use the AfterUpdate event on the textfield to change the buttonproperty Locked from True to False

In Code:

If Nz(Me.[textfield]) = "" Then
Me.[name button].Locked = True
Else
Me.[name button].Locked = False
End If

Hope this helps....

Grtz,

Kalin

 

[Zeroanarchy]

Thanks Kalin, thats what I was looking for