[AccessD] A2K - setting a form invisible on open

John,

What about
Screen.ActiveForm.Visible = False

Michael R. Mattys
www.mattysconsulting.com



----- Original Message -----
From: "John Colby" <jcolby at colbyconsulting.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, November 08, 2003 12:53 PM
Subject: RE: [AccessD] A2K - setting a form invisible on open


> Visible isn't a design time property.  From Access' help:
>
> You can set this property by using the object's property sheet (for
sections
> and all controls except page breaks), a macro, or Visual Basic.
> For forms, reports, and data access pages, you must set this property by
> using a macro or Visual Basic.
>
> Plus... see my explanation of LWS functionality.
>
> I can't set it at design time even if I wanted to.  If a user just
> dbl-clicks to open a form I have no opportunity to run a macro.  Thus I am
> left with Visual Basic to perform this magic.
>
> John W. Colby
> www.colbyconsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Lawrence
> (AccessD)
> Sent: Saturday, November 08, 2003 12:45 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] A2K - setting a form invisible on open
>
>
> Hi John:
>
> Here is a silly question. Why not set the form to visible = false
initially
> and then ...
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby
> Sent: Saturday, November 08, 2003 9:22 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] A2K - setting a form invisible on open
>
>
> No help.
>
> John W. Colby
> www.colbyconsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
> Sent: Saturday, November 08, 2003 11:26 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2K - setting a form invisible on open
>
>
> Hi John
>
> How about moving that command to OnLoad?
>
> /gustav
>
>
> > 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
>
> _______________________________________________
> 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