problem in diabling the command button

G

Guest

I have a button on a form which I want to diable of the record is empty or a new one.

I have put following code in the Current event of form (it is a tabular form)

Even if the me.Canumber is Null (it is a string type) it is not diabling the COmman button, the code is as below.

Any help

If Me.CANumber = Null Then Me.Command103.Enabled = Fals
 
T

tina

try:

Me!Command103.Enabled = Not IsNull(Me!CANumber)

that will enable *and* disable the button, based on whether or not CANumber
contains a value.


Diable the command button said:
I have a button on a form which I want to diable of the record is empty or a new one.

I have put following code in the Current event of form (it is a tabular form).

Even if the me.Canumber is Null (it is a string type) it is not diabling
Click to expand...
the COmman button, the code is as below.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enable or Disable Forms Button on a worksheet from code 1
Access Determine what query to run based on a checkbox 0
Command Button Enable/Disable 3
Auto Enabling of Command Button 3
OfficeXP to Office2007 Help 1
How to use multiple command button to copy user form data to multiple worksheet 0
Don't "see" my macro when I try to run it 4
Access Manage Attachments linked to a SubForm 0

Top