How do I grey out a button on my form?

[gagecres]

I'd like to grey out a button on my form if there are no records saved in the
database. Is there a way to do this?

 

[ghetto_banjo]

to make a command button "greyed out", or disabled, you can do it in
VB like:

me.buttonname.enabled = False



If you want to check if a table has no records you could do:

if DCount("*", "myTable") = 0 then
me.buttonname.enabled = False
Else
me.buttonname.enabled = True
end if

 

[gagecres]

In which object property do I insert this code?

 

[John W. Vinson]

In which object property do I insert this code?

The form's Current event property (it should say [Event Procedure] and you
would enter this code, appropriately edited, by clicking the ... icon and
choosing Code Builder).

If an entry in some other control should disable the button, put the same code
in the AfterUpdate event of that control as well.

 

[gagecres]

Thanks to you both. This worked perfectly.

In which object property do I insert this code?

The form's Current event property (it should say [Event Procedure] and you
would enter this code, appropriately edited, by clicking the ... icon and
choosing Code Builder).

If an entry in some other control should disable the button, put the same code
in the AfterUpdate event of that control as well.