Properties Window

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I'm running Access 2003 with a Access 2000 formatted
database.

Because of things I cannot control, all forms displayed
in the database must be modal...which is fine. However,
I cannot find anywhere in any documentation where you can
dismiss, or close the Properties window when opening a
form. I have people running all different versions of
Access and cannot use an MDE file so I create a copy of
the database and set the startup options not to display
the database panel. That way only the forms are
displayed. However, when a form is opened, that stupid
Properties window opens up and it cannot be closed
because the form is always opened as modal.

How can I (using VBA code in the Open event) close the
properties window?
 
Peter, you can set the Properties window so it only displays in Design view.

Open your form. Open the Properties box.
On the Other tab, the last item is Allow Design Changes.

You cannot set this property while the form is in use, but if you have lots
of forms, you could loop through each AccessObject in
CurrentProject.AllForms to get their names, OpenForm each in design view
(Hidden), and set the AllowDesignChanges to False.

If you have multiple users with different versions, hopefully you have split
the database (Tools | Database Utilities | Database Splitter), so that each
user can have their own local front end in their own version.
 
Dear PeterM:

I am sure you can use VBA to do this, but have you tried setting the "Allow
Design Changes" to "Design View Only" in the property settings for your
forms? I believe that this will prevent the display of properties sheets in
form view.

HTH
Fred Boer
 
Does that mean you are going to charge double if you offer
twice in the same thread?

I hope you will charge double for the *free* advice which
is the intention of these newsgroup. <BG>

Van T. Dinh
MVP (Access)


-----Original Message-----
I am from the Access support department at
Click to expand...
http://www.enterpriseprojectconsulting.com and we would be
happy to assist you in resolving your issue.
 
Back
Top