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.

 

[slharman1]

View attachment 95038

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

 

[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!