Results 1 to 5 of 5
  1. #1
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Allow Design Changes (Access 2000)

    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?
    Regards
    John



  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Allow Design Changes (Access 2000)

    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.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Allow Design Changes (Access 2000)

    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.
    Regards
    John



  4. #4
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Allow Design Changes (Access 2000)

    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
    Attached Images Attached Images

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Allow Design Changes (Access 2000)

    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
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •