Charlotte Foust
cfoust at infostatsystems.com
Thu Jul 24 15:59:34 CDT 2003
You use the Open event of the report and use a DoCmd.ShowToolbar "MyMenubar", acToolbarNo to turn off the menu in question. Then in the close event of the report you turn it back on using acToolbarYes. At the same time, you can use a similar statement to turn on and off a toolbar or menubar associated specifically with that report if you have one. Charlotte Foust -----Original Message----- From: Steven W. Erbach [mailto:serbach at new.rr.com] Sent: Thursday, July 24, 2003 12:50 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Hiding Menubar on a Report Susan, >> I want to do the same for my menu bar on my reports. But, reports >> don't have an on_load event. How can I do this? << How about issuing the command to turn off the menu bar just before the DoCmd.OpenReport statement in your code and then turning the menu bar back on in the On Close event procedure for the report? Regards, Steve Erbach Scientific Marketing Neenah, WI "Nothing so needs reforming as other people's habits." - Mark Twain _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com