Menu Bar Security and UNHIDING columns

I designed an application where I want to disable ability for users to modify
any design elements; however, I want the users to be able to hide and unhide
columns in forms that appear in datasheet view. The current STARTUP settings
allow them to HIDE columns, but there is no ability to UNHIDE the columns.
So they hide columns, print the datasheet, and close the form and now the
columns are hidden from the next form user. My STARTUP settings are Allow
Default Shortcut Menus. That's it. How can I allow them to see an option to
UNHIDE hidden columns? Many thanks!

You can add an "Unhide Columns" button to the menu bar. Right-click
anywhere on the menu bar and select "Customize..." to open the "Customize"
dialog window. Select the "Commands" tab. In the "Categories" list box on
the left, select "Datasheet." In the list box on the right, find and drag
the "Unhide Columns" item to the menu bar. (You may want to customize this
text to display "Columns" instead of the entire two words on your menu bar.)
Now this new menu item will be available for all forms that use the
Datasheet View. However, users will be able to hide _and_ unhide columns
through this wizard, so it's not just for unhiding columns.

You've just modified your menu bar, but if you can do this, then so can your
users. To prevent your users from altering any of the command bars after
you're done, select the "Toolbars" tab in the "Customize" dialog window.
The "Menu bar" item will be selected in the list box. Select the
"Properties" button. Uncheck "Allow Customizing." Select the "Close"
button to save your choice. Select the "Close" button again to close the
"Customize" dialog window.

If you are interested in customizing your command bars even further, you may
be interested in the tutorial, "How to add a custom button on the command
bar to run code on a form" tutorial on this Web page:

http://www.Access.QBuilt.com/html/fo...l#CustomCmdBar

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)


"AccessNana" wrote in message
...
I designed an application where I want to disable ability for users to
modify
any design elements; however, I want the users to be able to hide and
unhide
columns in forms that appear in datasheet view. The current STARTUP
settings
allow them to HIDE columns, but there is no ability to UNHIDE the columns.
So they hide columns, print the datasheet, and close the form and now the
columns are hidden from the next form user. My STARTUP settings are Allow
Default Shortcut Menus. That's it. How can I allow them to see an option
to
UNHIDE hidden columns? Many thanks!