Shortcut menu bar question

[Salad]

A97. If you set a forms properties to ShortcutMenu = No, the entire
form is disabled from displaying a shortcut menu.

If you set the property to Yes, all controls have a shortcut menu.

I have a form that I would like a shortcut menu on 1 control and no
shortcut on any other control in the form. But the controls that have
no shortcut display a default shortcut.

Access help states " If you set the ShortcutMenuBar property to a value
that isn't the name of an existing shortcut menu or menu bar macro, the
form, form control, or report won't have a shortcut menu (the default
shortcut menu won't be shown)."

Can someone explain that? For grins, I entered
NoShortcutMenu
and instead of displaying nothing it displayed an error message
complaining about the macro not being found.

Is this something trapped with a mouse-down event?

[deko]

> A97. If you set a forms properties to ShortcutMenu = No, the entire

form is disabled from displaying a shortcut menu.

If you set the property to Yes, all controls have a shortcut menu.

I have a form that I would like a shortcut menu on 1 control and no
shortcut on any other control in the form. But the controls that have
no shortcut display a default shortcut.

Access help states " If you set the ShortcutMenuBar property to a value
that isn't the name of an existing shortcut menu or menu bar macro, the
form, form control, or report won't have a shortcut menu (the default
shortcut menu won't be shown)."

Can someone explain that? For grins, I entered
NoShortcutMenu
and instead of displaying nothing it displayed an error message
complaining about the macro not being found.

Is this something trapped with a mouse-down event?

I have a form where I use the full shortcut menu on some *subforms* and a
limited shortcut menu on other subforms (Access 2003). To accomplish this I
set the "Shortcut Menu" property on the parent form to "Yes" (leaving the
"Shortcu Menu Bar" property blank), and then set the "Shortcut Menu Bar"
property on the subform to "MyCustomMenuBar" where I want to limit the menu
selections. I have not needed to create different menu bars (Tools >>
Customize >> Toolbars) for different controls on the same form, but that's
what I would suggest trying.

[Salad]

deko wrote:

I have a form where I use the full shortcut menu on some *subforms* and a
limited shortcut menu on other subforms (Access 2003). To accomplish this I
set the "Shortcut Menu" property on the parent form to "Yes" (leaving the
"Shortcu Menu Bar" property blank), and then set the "Shortcut Menu Bar"
property on the subform to "MyCustomMenuBar" where I want to limit the menu
selections. I have not needed to create different menu bars (Tools >>
Customize >> Toolbars) for different controls on the same form, but that's
what I would suggest trying.

But you still have a shortcut.

Access help states " If you set the ShortcutMenuBar property to a value
that isn't the name of an existing shortcut menu or menu bar macro, the
form, form control, or report won't have a shortcut menu (the default
shortcut menu won't be shown)."

If I am reading this correctly, no shortcut should be displayed. The
help file does not have an example on how to implement this.

If I enter ="" or =False, I get an empty button menu. Now if I could
make that button invisible that'd be great.

[deko]

> If I enter ="" or =False, I get an empty button menu. Now if I could

make that button invisible that'd be great.

Using an empty menu bar has the same result - not sure if it can be made
invisible. The button won't do anything, so that's close enough for me.

[Albert D. Kallal]

Hum...you might be able to trap the error.

However, the simple solution to me seems rather simple:

make a blank menu bar (call it blank1).

Then, for the form..just specify the blank1 for the shortcut...and then for
that one control just specify the other shortcut menu you want....

You could also perhaps have the right click launch help..or perhaps sorting
else of use..like launch the calculator or something. (since, if you do
leave it blank..then right click does give you a grey square..but that is
not really a problem...and as mentioned..if it is a problem..then make the
right click launch the calculator..or something else of use).
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pl******************@msn.com
http://www.attcanada.net/~kallal.msn