Microsoft Access Properties: What’s The ‘HasModule’ Property In An Access Database?

Microsoft Access Properties: What’s The ‘Has Module’ Property In An Access Database?

There are many Microsoft Access properties to set and control your Access database with and when combined in certain permutations, it changes the whole dynamics of your database and how they will perform and behave.

One property I want to mention here affects performance and the overall file size of your database and applies to the main form or report properties. The property is called ‘Has Module’.microsoft access properties

Microsoft Access Properties: What’s The ‘Has Module’ Property In An Access Database?

The ‘Has Module’ property is a Boolean value (which means either a True or False option) and by default it is set as No (False). When you add a class module (VBA code), this property automatically changes to Yes (True).

With this property, a form or report loads and runs faster when the value is set to False improving the general performance and keeping file sizes smaller as VBA code needs to compile to the machine’s run time machine (meaning more allocated space).

Even if you just delete the actual VBA code and leave this Access property set as True, you are in essence wasting space and de-optimising too.

If you change this value from True to False you will be prompted and warned about the module being removed and VBA code will be lost. This is the best way to remove VBA code.

Microsoft Access properties can be found everywhere and to set and manage the ‘Has Module’ property you need to be in the design view of a form or report property’s region, looking into the ‘Other’ tab from the Property Sheet or Properties Window view.

If you want to learn about good form and report design techniques and how to control Access properties, then take a look at some of my Microsoft Access eBook offers.

This entry was posted in Forms, Modules, MS Access, Reports, VBA and tagged , , , , . Bookmark the permalink.

2 Responses to Microsoft Access Properties: What’s The ‘HasModule’ Property In An Access Database?

  1. PR says:

    If you want to grow your knowledge only keep visiting this web site and be updated with the most up-to-date gossip posted here.

  2. Ben Beitler says:

    When you strip out a module (by choosing the value No), any macros associated to the form or report are left intact and will still work.
    Any VBA code outside the form or report can still call objects to the actual form and report too.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.