Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Location
    Norwalk, CT
    Posts
    12

    Change a form property in all forms

    I've tried every syntax I can think of to allow me to change the "AllowDesignChanges" property of all my forms to False (which I'm pretty sure allows design changes only at design time... How does MS come UP with some of these defaults!) but I haven't found it yet. I can get at the properties of open forms, but I can't figure out how to get at the properties of AllForms. Help?

    Thanks,

    Kevin

  2. #2
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    Through code, open each form in Design View (DoCmd.OpenForm "Formname", acDesign)
    Set its property to false
    Close the form

    Good luck

  3. #3
    Join Date
    Apr 2002
    Location
    Norwalk, CT
    Posts
    12

    Change a form property in all forms

    Thanks Danny. I was hoping for the code which would let me say

    for each Frm in ???????
    Frm.Properties("AllowDesignChanges")="Design"
    next Frm

    or whatever the proper syntax is.

Posting Permissions

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