Custom Menu Bar toggle command question

[inso18]

Hello all!

I have a form that can be viewed by either customer name or customer sir name. So I've created a menu bar with a custom menu called "View By", and 2 commands: "Name" and "Sir Name". Each command activates a macro that alters the form accordingly.

I need something else for the menu: (which I can't configure via "Customize..." option) When a user will activate "Name", a toggle (V-shaped) icon will appear next to "Name" and disappear from "Sir Name", and likewise, when user will activate "Sir Name" a toggle icon will appear next to "Sir Name" and disappear from "Name", so the user will know by which method the form is being viewed now.

I figure it's got to do with changing the menu bar properties via VBA, but I haven't found anywhere anything on that.

Can anyone please help,
thanks a lot
inso18.

 

[SeeThru]

Rather than on the button, you could consider changing the form to display a title 'Contacts (Sorted by Company)' or Contacts (Sorted by Surname)', triggered by the button.

Which version on Access are you using?

SeeThru
Synergy Connections Ltd - Telemarketing Services

 

[inso18]

SeeThru,
Yeah, I could change the title, but it looks less professional than a "V" on the menu bar command

I'm using MS-Access 2003

 

[TheAceMan1]

How are ya inso18 . . .

[blue]SeeThru[/blue] has you in tow! I can't help but aggree!

It doesn't matter how you do it!, but a display of the selection in the form (unbound textbox with prompt or color or something) to save the extra click to find out, is in order!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]