Dan Waters
dwaters at usinternet.com
Sat Nov 8 14:23:08 CST 2003
I re-read this and realized that it sounds like the form being set to hidden will cause the form to automatically close after the code is finished. Not! The code behind the form closes the form. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Saturday, November 08, 2003 2:12 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] A2K - setting a form invisible on open John, I have a startup form with quite a bit of startup code behind it. To make it invisible, I go to the database window, right-click the form, then select properties. Then check the Hidden checkbox. Now the form will never display, but all the code behind the form runs from the form's Open event. The form also closes itself after it does all it's things and opens the switchboard form. For you to be able to see and select the form from the list in the database window, go to Tools|Options, then select the View tab and check the Show Hidden Objects checkbox. Now, when the form list is displayed in the database window, the startup form's small icon will be 'grayed out' to indicate that this form is hidden. As long as your users can't muck around in Tool|Options and can't open the database window, this may work for you. HTH! Dan Waters Quality Process Solutions -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Saturday, November 08, 2003 10:11 AM To: AccessD Subject: [AccessD] A2K - setting a form invisible on open I have a form I want to open invisible every time it opens, regardless of how it is opened. I placed me.visible = false in OnOpen. That doesn't work! The strange part is that if I place a breakpoint on the line and stop execution on the me.visible = false, then continue, the form correctly hides itself. Has anyone ever seen such a strangeness? John W. Colby www.colbyconsulting.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com