How do I "gray out" Shortcut Menu choices?

[Bill Mitchell]

Hi,

I'm creating shortcut menus using macros and code. I've noticed that Access
has the ability to "gray out" choices that you don't want available depending
upon parameters.

Can anyone tell me how to cause a shortcut menu item to be grayed out?

Thanks.

Bill

 

[Sylvain Lafontaine]

Use something like
Application.commandbars("mybar").Controls("mycontrol").Enabled=False

More information at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc97/html/msdn_replace.asp

S. L.