Disable command button

[slharman1]

Apparently you cannot disable a command button. Is it normal to write code to cancel the on click event if a forms control has data (is not null) or in the case of a date/time field > 0 ?

 

[theDBguy]

Hi. You should be able to disable a button as long as it doesn't have the focus.

Sent from phone...

 

[arnelgp]

you can have a Code in to the Form's Current Event to disable/enable the command button:

Private Sub Form_Current()
Me!ButtonX.Enabled = IsDate(Me!DateField)
End Sub

again on the DateField you set it on it's AfterUpdate Event:

Private Sub DateField_AfterUpdate(cancel As Integer)
Call Form_Current
End Sub

 

[slharman1]

Hi. You should be able to disable a button as long as it doesn't have the focus.

Sent from phone...

A command button?

 

[theDBguy]

A command button?

Yes.

 

[Pat Hartman]

 

[slharman1]

View attachment 95038

But when I disable it and then click the button, underlying code still runs.
man I doing something wrong?

 

[Pat Hartman]

That is jogging a faint memory. You may have to make the button invisible rather than disabling it.

Although, I just tried it and the code didn't run when I disabled the command button. I used two separate buttons though so I didn't disable it using VBA. I just set the enabled property to false. Maybe when you set the property in code, there is a delay before it takes effect.

Please post your code

 

[theDBguy]

But when I disable it and then click the button, underlying code still runs.
man I doing something wrong?

Hmm, when a command button is disabled, it should turn gray (I think). Did yours do that? If not, maybe it isn't disabled. Also, you can verify if it's disabled or not by checking its Enabled property using code. Just a thought...

 

[LarryE]

You can just set its Enabled property to False
If your command button is named MyCommand, then it's
Me.MyCommand.Enabled=False
You can also use the Visible property to hide or unhide the button.

 

[slharman1]

Thanks everyone, hide it is!