Hide Properties on Open Database

[Guy Boswell]

Hi All,

I am working in MS Access 2003 and Windows 2000 professional SP4.

When I open a database with a Display Form defined in Startup the properties for the form sometimes diplay in a pop up. The switch for display or not seems to be whatever I had set last time I used Access, this database or any other.

Before I distribute my database to users can I do something that switches off the properties display pop-up when it is opened? Some of my users will also develop their own databases so may have the properties pop-up open whilst designing their own forms. But I don't want them to see it when they open my database, at least not be default.

I expected making a .mde version would solve this problem but it doesn't. When you open the .mde you still see the properties of the startup form.

Is there something in Startup I should be setting or some code I can put into the On Open event of the Startup Form?

Thank you very much fro your help.

 

[boblarson]

No, you just need to make sure that you close the form properties dialog before you close the form and then close the database so it doesn't show up.

 

[boblarson]

Actually, there is one thing you can set. In each form's properties on the OTHER tab, there is a property ALLOW DESIGN CHANGES and if you set that to DESIGN VIEW ONLY I believe you won't get the property dialog at all when the form is in form view.

 

[Guy Boswell]

Thank you very much Bob - that is exactly what I needed