When designing a MS Access form you can easily disable the minimize and maximize buttons by selecting the appropriate option in the form’ properties window. Such an option doesn’t exist for Access reports. However you can still mess with these report’ features by making use of VBA and the Win32 API.

To disable the minimize and or maximize buttons of a report window, place the following code in a VBA code module:

Then write the following code for the report’ OnOpen event:

Simply comment out one of the lines to disable only the minimize or maximize button.

Aswin van Woudenberg

I'm a software engineer based in the Netherlands. Besides software, I am also interested in areas ranging from music and art to mathematics and literature.

Leave a Reply

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