Can't add Unfreeze Columns to a custom menu?

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

Guest

I have a form with a subform that displays a datasheet. I'd like to let the
user freeze and unfreeze columns.

Two problems:

1. When I open the application in runtime mode, I can't get the subform to
provide right-click options for the columns.

2. To get around problem 1, I have added the datasheet options to a custom
menu. I can add the Freeze Columns function, but can't seem to find the
"Unfreeze Columns" function in any of the menu commands.

All help appreciated.
 
to get to the Unfreeze menu option, open the subform in Form view. make sure
the default menu is showing. now right click on the menu bar and click the
Customize... option. open your custom menu, if it's not already showing. on
the default menu, click the Format option, click on the Unfreeze All Columns
option in the dropdown list, HOLD DOWN THE Ctrl KEY ON THE KEYBOARD (so that
a small plus sign (+) shows beside your mouse pointer), and drag the option
onto your custom menu. be careful when you do this - if you don't see the
plus sign, you're not copying the option, you're *moving* it!

hth
 
You wizard! Works like a charm. I never knew you could get stuff from the
existing menus. Of course, now I have to write the documentation explaining
it, but what a gem of a trick. Thank you, thank you. Now, any idea on how to
get the right-click function for the columns of the subform?

Thanks again.
 
Okay, found it! I assigned a the new menu as the shortcut menu bar for the
subform. Presto! Right-clicking.

To all of you who cogitated on this, thanks very much. And thanks especially
for the tip about the shortcut menu issue. It gave me a excellent place to
start looking.

r
 
you're welcome :)


Reliza said:
You wizard! Works like a charm. I never knew you could get stuff from the
existing menus. Of course, now I have to write the documentation explaining
it, but what a gem of a trick. Thank you, thank you. Now, any idea on how to
get the right-click function for the columns of the subform?

Thanks again.
Click to expand...
 
Back
Top