Allow Design Changes (Access 2000)

Topic

New Reply

Access 2000 brought in the “Allow Design Changes” property of forms, which defaults to “All views”. With this setting the Propeties box appears when using a form in form view.

I never want the Properties box to appear in form view, so I have to remember to change this setting to “Design View” only for every new form.

Is there any way of changing the default , so that all new forms only show the properties box in Design view? What happens in later versions of Access?

Reply | Quote

Replies

It’s the same in Access 2002. There are a number of irritatingly stupid defaults, neither of which can be changed as far as I know:
– Each new database has Track Name AutoCorrect on.
– Each new table has SubDatasheets set to [Automatic].
– Each new form has Allow Design Changes set to All views.
As has been remarked elsewhere in the Lounge, it is clear that the Microsofties don’t really use their own products.

Reply | Quote

Thanks Hans

I also set the “control box” property to No, “Min Max buttons” to none, and “Close button” to No for every form.

Sometimes I create a empty form with all these properties set ( and a Command button for closing the form) and try I use a copy of it for every new form. But I usually forget after a while.

Reply | Quote

I also find it extremely annoying to view new form in Form view & see the stupid Properties dialog & Form Design toolbars present. There’s no way to change default, the closest you could do is create dummy blank form with desired settings and designate this form as the template form for database (Options dialog, Forms/Reports tab, “Form Template” box, or set in VBA using SetOptions method). Any new form created will reflect the template form’s settings – most of the settings you mentioned, such as “Allow Design Changes”, MinMax Buttons, etc will “stick” & be reflected when new form created. Note that designating template form will have no effect on existing forms, nor on forms created using so-called Wizard. Also a form template applies only to current database, you’d have to import template form into any new db created & reset Form Template setting. If you disable the Control Box setting by default, you may want to customize the Form View Title Bar shortcut menu to include the “Close” command so you have way to close newly created form w/o having to go back to design view – see illustration.

HTH

Reply | Quote

Thanks for that suggestion.

Also, if you create a plain form with the settings you want, you can add it to the list of formats offered by the form wizard, and this sticks for all databases.

Open the form in Design view, and go to Format…Autoformat…Customize

Reply | Quote

Thanks for that suggestion.

Also, if you create a plain form with the settings you want, you can add it to the list of formats offered by the form wizard, and this sticks for all databases.

Open the form in Design view, and go to Format…Autoformat…Customize

Reply | Quote

I also find it extremely annoying to view new form in Form view & see the stupid Properties dialog & Form Design toolbars present. There’s no way to change default, the closest you could do is create dummy blank form with desired settings and designate this form as the template form for database (Options dialog, Forms/Reports tab, “Form Template” box, or set in VBA using SetOptions method). Any new form created will reflect the template form’s settings – most of the settings you mentioned, such as “Allow Design Changes”, MinMax Buttons, etc will “stick” & be reflected when new form created. Note that designating template form will have no effect on existing forms, nor on forms created using so-called Wizard. Also a form template applies only to current database, you’d have to import template form into any new db created & reset Form Template setting. If you disable the Control Box setting by default, you may want to customize the Form View Title Bar shortcut menu to include the “Close” command so you have way to close newly created form w/o having to go back to design view – see illustration.

HTH

Reply | Quote

Thanks Hans

I also set the “control box” property to No, “Min Max buttons” to none, and “Close button” to No for every form.

Sometimes I create a empty form with all these properties set ( and a Command button for closing the form) and try I use a copy of it for every new form. But I usually forget after a while.

Reply | Quote

It’s the same in Access 2002. There are a number of irritatingly stupid defaults, neither of which can be changed as far as I know:
– Each new database has Track Name AutoCorrect on.
– Each new table has SubDatasheets set to [Automatic].
– Each new form has Allow Design Changes set to All views.
As has been remarked elsewhere in the Lounge, it is clear that the Microsofties don’t really use their own products.

Reply | Quote