Form Controls vs. ActiveX Controls

Posted by: shepherdkaisk30 on 14 April 2021, 6:12 pm EST

  • Posted 14 April 2021, 6:12 pm EST

    Hello!

    I am designing a data entry form for a work project and have decided to use some form of controls to help reduce the amount of data entry points. It's an expandable document, so I have discovered that hiding/unhiding rows can have some funky results with control forms. I found a work around for the short term, but with scaling it up would lead to a lot of seemingly unnecessary VBA code. After some digging around I found that ActiveX controls seem to have more power to format it the way I want, BUT people seem to agree that you shouldn't use ActiveX controls unless necessary.

    My questions: what is the preferred way to approach using controls in your document?

    Is there any major reasons NOT to use ActiveX controls on a relatively small document?

    What is your favorite to use?



    Questions I can anticipate now: This will eventually export to some sort of database. Don't know if that info is relative, but thought I would include it.
  • Replied 15 April 2021, 6:31 pm EST

    shepherdkaisk30 said:
    Hello!

    I am designing a data entry form for a work project and have decided to use some form of controls to help reduce the amount of data entry points. It's an expandable document, so I have discovered that hiding/unhiding rows can have some funky results with control forms. I found a work around for the short term, but with scaling it up would lead to a lot of seemingly unnecessary VBA code. After some digging around I found that ActiveX controls seem to have more power to format it the way I want, BUT people seem to agree that you shouldn't use ActiveX controls unless necessary.

    My questions: what is the preferred way to approach using controls in your document?

    Is there any major reasons NOT to use ActiveX controls on a relatively small document?

    What is your favorite to use?omegle



    Questions I can anticipate now: This will eventually export to some sort of database. Don't know if that info is relative, but thought I would include it.

    Thank you my issue has been solved
  • Replied 26 January 2022, 2:45 pm EST

    Appreciate the fix [url=https://elmontecustomcabinets.com/custom-cabinets-van-nuys/],[/url] guys.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels