[AccessD] A2K - setting a form invisible on open

John Colby jcolby at colbyconsulting.com
Sat Nov 8 11:53:56 CST 2003


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





More information about the AccessD mailing list