Customize MenuBar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
I created a Custom Menu Bar, I need to add in the "Hide Column" and
"Unfreeze Column" command for user but I cannot find these two command under
the Customize Window. Is there anyway to add these in? or how can I create a
custom command in the menu bar by using Docmd.Runcommand acCmdHideColumns? I
prefer this command in the menu bar because my form has limited space for
command button. Thanks
 
KK,
I did this in A97.
Open any table in table view, display your custome menu bar along with
the Default Access Datasheet Menu Bar.
Right click any menu and select Customize. Find Format -UnHide and Hide
in the Access menu.
While holding the Ctrl key down (to copy), drag the UnHide and Hide
commands from the Access Menu Bar to your custom bar.
They appear as blank on your custom menu bar, since they never had an
icon image. While still in Customize mode, right click the blank UnHide
button, and use the button properties menu to either create or copy a bitmap
icon for your button. Do the same for the Hide button.

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
go to Tools | Customize. then you can drag 'n drop the commands from the
built-in Format menu. just make sure you hold down the Ctrl key (you'll see
a small + sign next to your mouse pointer) when you drop - otherwise, you'll
*move* the menu selections from the built-in menu to your custom menu,
instead of *copying* them.

hth
 
Back
Top